Hi,
I'm having one of those days where my brain just isn't getting it, so please can you help a brother out.
I've attached an example, using sumproduct to COUNT an array. Unfortunately it's not quite working. I've highlighted the cells yellow with the answer I'm getting and green with what it should be.
The idea is to COUNT how many rows have a value for the location based on if it's "Prelim" or "Classification".
For location V026 there 8 rows with a value greater than 0 in the "prelim" category, but because there are two columns the value I'm getting is 9
For location V026 there 4 rows with a value greater than 0 in the "classification" category, but because there are four columns the value I'm getting is 13
Would appreciate your help
Thanks
Bookmarks