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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#value error for sumproduct using RIGHT cmd 0
Sumproduct not working 5
Sumproduct with cells >0 2
Sumproduct is returning irregular values 11
sumproduct issues 1
Basic help needed using sumproduct to do a league table 6
Using Sumproduct when some of the values are null 5
returning text; alternative to sumproduct/sumif? 4

Top