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
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[bibi12]

countif

if you do not insist on "countif" here is something to consider

Sub countCells()
Dim x As Variant
Range("your choice", Range("your choice").End(xlUp)).Select
For x = 5 To Selection.Rows.Count - 1

If ActiveCell.Value > your choice Or ActiveCell.Value < your choice or other choice Then
Range(your choice).Value = Range(your choice).Value + 1
End If
Next x
End Sub