EXCEL multiple criteria in countif function
 

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

--
Message posted from http://www.ExcelForum.com

EXCEL multiple criteria in countif function
 

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



"tvbrower " wrote in
message ...
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"))

-Travis


---
Message posted from http://www.ExcelForum.com/

EXCEL multiple criteria in countif function
 

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")



--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
I Feel Great!
---------------------------------
"tvbrower " wrote in message
...
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"))

-Travis


---
Message posted from http://www.ExcelForum.com/

EXCEL multiple criteria in countif function
 

Chip Pearson wrote:
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