I'm nearly there but I'm stumped on the logic... (I've attached an example workbook with my problem, and my own attempt to fix it.)
At first I used COUNTIFS, but I moved the same logic over to SUMPRODUCT as I wanted an array to be tested in the 3rd criterion.
I'm looking for a formula to count the rows that:
A) are >0 in column J
B) are blank in column I
C) have the sum of columns $C:H as >0
what I've tried
=SUMPRODUCT((J9:J99>0) * (I9:I99="") * ($C9:H99>0))
which nearly gets it, BUT instead of counting the rows where the above criteria are all true (once per row), it instead counts rows multiple times if there are multiple non=blanks in the C:H range of that row...
HELP!
Thanks
Bookmarks