Can I "countif" multiple conditions?

Posted by Andrew Miller on October 02, 2001 12:55 PM

I have several columns. 3 of these columns have independent pieces of data. I want to be able to count the instances where a certain 3 pieces of data line up. For instance I want to count if "1" appears in column 1 and "2" in column 2 and the number "3" in column 3 all in the same row. I need a tally of every row where these three pieces of data line up. Thanks.

Posted by Andrew miller on October 02, 2001 12:58 PM

I should have said if I have a "1" in column A and "2" in column B and "3" in column C.

Posted by Aladin Akyurek on October 02, 2001 12:58 PM

Re: Can I

Try:

=SUMPRODUCT((A1:A10=1)*(B1:B10=2)*(C1:C10=3))

Aladin

Posted by Aladin Akyurek on October 02, 2001 12:59 PM

See above. (NT)