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: [email protected] For additional commands, e-mail: [email protected]
