COUNTIF With two criteria

[Boran Düzgün]

How can i count rows with two criteria. I can use COUNTIF with only one
criteria... does it posible to count with two criteria..

For example, I need to count the A's in the column A1:A100 which satisfies
the condition "O" in column D1100.

 

[mjones]

Perhaps you can nest your if statements.

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="A"),--(D1100="O"))


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Dave Peterson]

=sumproduct(--(a1:a100="A"),--(d1:d100="o"))

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

 

[Sandy Mann]

Try:

=SUMPRODUCT((A1:A100="A")*(D1100="O"))

--
HTH

Sandy
[email protected]
[email protected] with @tiscali.co.uk