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

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