Countif
 

How do I say count "S" and "I" and "R"?

Hello. One method
.....=COUNTIF(Range,"S")+COUNTIF(Range,"I")+COUNTI F(Range,"R") "Range" is the
cluster of cells from which you need to pluck the count.
"Natalie" wrote in message
...
How do I say count "S" and "I" and "R"?

try
=sumproduct((a1:a21={"s","i","r"})*1)

--
Don Guillett
SalesAid Software

"Natalie" wrote in message
...
How do I say count "S" and "I" and "R"?

Another option is:

=SUM(COUNTIF(A1:A100,{"S","I","R"}))

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Natalie" wrote in message
...
How do I say count "S" and "I" and "R"?