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:CW500)) 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