EXCEL multiple criteria in countif function

[tvbrower]

This is a question similiar to ROBERT's Dated 5/18/2004

Is it possible to have two criteria for a countif
statement like (COUNTIF(A1:A10,="X"))or(COUNTIF
(A1:A10,"T"))

-Travi

 

[Chip Pearson]

Travis,

Use two COUNTIFs and add the results. E.g.,

=COUNTIF(A1:A10,"X")+COUNTIF(A1:A10,"T")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Patrick Molloy]

I don't have excel open just now, but
=SUM( (A1:A10="X") * (B1:B10="Y") )

your formula would be simpler:

= COUNTIF(A1:A10,"X") + COUNTIF (A1:A10,"T")

 

[Alan Beban]

Travis,

Use two COUNTIFs and add the results. E.g.,

=COUNTIF(A1:A10,"X")+COUNTIF(A1:A10,"T")

Or =SUM(COUNTIF(A1:A10,{"T","X"}))

Alan Beban