sumproduct issues

J

jxbeeman

I've been trying to find out why my sumproduct function isn't working! The
issue is that it is counting the cells that are blank as well as the ones
that contain values. for example

=SUMPRODUCT(--(CW7:CW50>0)) returns 44 where it should return 0
cells 7--> 50 are blank and have no values
formated as a number and pasted values as well.

Any ideas??
Thanks, Josh
 
P

PCLIVE

Maybe cells CW7:CW50 only appear blank. There could be a space in the cell.
If the values will truly be numbers, then you might try:

=SUMPRODUCT(--(CW7:CW50>0),--ISNUMBER(CW7:CW50))

HTH,
Paul
 
Top