Hey Biff, I spoke too soon. I re-created my example in Excel and copy
amd pasted your formula and it worked perfectly, however, when I try to
recreate the formula for my list, Excel gives me an answer of "0". Here
is the formula I tried to use:

=SUMPRODUCT(--(C2:C134=0),--(D2:D134=20))

Column C is made up of 133 entries of either "0" or "1" while
column D is made up of 133 entries ranging from "18" to "22". The
formula appears to be correct, however Excel still returns me value of
"0" when I should be getting an answer of atleast 20 because I counted
the cells twice. Could you let me know what I am doing wrong here,
please?


--
hadmybreaktoday
------------------------------------------------------------------------
hadmybreaktoday's Profile: http://www.excelforum.com/member.php...o&userid=26463
View this thread: http://www.excelforum.com/showthread...hreadid=397327