poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From russsur <russ...@comcast.net>
Subject Re: Evaluator resulting in "Unexpected ptg class" error message
Date Tue, 19 Dec 2017 22:29:31 GMT
Hi Greg,

Thanks for the info. I worked around this issue by simply adding sums
together for each of the array options:

=SUM(COUNTIFS(QueryResults!$N$2:$N$186,"No
Run",QueryResults!$F$2:$F$186,$D7,QueryResults!$Q$2:$Q$186,$B$4)) +
SUM(COUNTIFS(QueryResults!$N$2:$N$186,"",QueryResults!$F$2:$F$186,$D7,QueryResults!$Q$2:$Q$186,$B$4))

The recalculation is working fine after changing this.

Thanks,

Russ



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message