=SUMPRODUCT formula is counting the blank cells as well as zero's
 

Hello,

I am using the following to count a column of zeros in a worksheet if the
zeros occur during specific times.

=SUMPRODUCT(--(pathfinder_dump!G1:G10000=TIME(1,0,0)),--(pathfinder_dump!G1:G10000<=TIME(1,29,59)),--(pathfinder_dump!I1:I10000=0))

The trouble is that the formula is counting the blank cells as well. Can
someone tell me how to modify so the formula only counts the zeros?

Thanks

=SUMPRODUCT formula is counting the blank cells as well as zero's
 

Hi

You could add a NOT(ISBLANK()) to the end:
=SUMPRODUCT(--(pathfinder_dump!G1:G10000=TIME(1,0,0)),--(pathfinder_dump!G1:G10000<=TIME(1,29,59)),--(pathfinder_dump!I1:I10000=0),--(NOT(ISBLANK(pathfinder_dump!I1:I10000))))


Hope this helps.
Andy.


"JR" wrote in message
...
Hello,

I am using the following to count a column of zero's in a worksheet if the
zero's occur during specific times.

=SUMPRODUCT(--(pathfinder_dump!G1:G10000=TIME(1,0,0)),--(pathfinder_dump!G1:G10000<=TIME(1,29,59)),--(pathfinder_dump!I1:I10000=0))

The trouble is that the formula is counting the blank cells as well. Can
someone tell me how to modify so the formula only counts the zero's?

Thanks