=SUMPRODUCT(--(A1:A10=0),--(B1:B10=0),--(A1:A10<""))

--
HTH

Bob Phillips

"LucasBuck" wrote
in message ...

How could I make a function that would look at two columns of data, and
count how many have a value of zero in both cells of a row? ie
1 2
3 5
0 0
2 2
And I would get a count of 1 to display in a cell reporting how many
sets of 0 there are


--
LucasBuck
------------------------------------------------------------------------
LucasBuck's Profile:
http://www.excelforum.com/member.php...o&userid=19710
View this thread: http://www.excelforum.com/showthread...hreadid=467158