Okay, I've seen multiple posts on this but I am not having any luck trying an array with SUM and SUMPRODUCT.
I have multiple data fields but I want the count if I:I is equal to "FLUID", J:J is not equal to "VERIFIED", and L:L has any text that begins in "Y". Then the same for the sum.
The...