EXCEL multiple criteria in countif function

T

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
 
C

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
 
P

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