David
asked on
Sumproduct
The below formula is returning a number but it should be 0. Please see attached test file. The cell in yellow is the one I'm having problems with. It seems to be counting blank cells as 0.
=SUMPRODUCT((Responses!$A$ 2:$A$1000= $B7)*(Resp onses!$B$2 :$B$1000=L $4))
Any help would be greatly appreciated!
Thanks.
test.xls
=SUMPRODUCT((Responses!$A$
Any help would be greatly appreciated!
Thanks.
test.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm using 2003.
OK, in that case I recommend Saqib's approach, add another check to the SUMPRODUCT formula
regards, barry
regards, barry
ASKER
Thank you!
=COUNTIFS(Responses!$A$2:$
regards, barry