Countif

[Guest]

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

 

[Roger H.]

Hello. One method
.....=COUNTIF(Range,"S")+COUNTIF(Range,"I")+COUNTIF(Range,"R") "Range" is the
cluster of cells from which you need to pluck the count.

 

[Don Guillett]

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

 

[RagDyeR]

Another option is:

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

--

HTH,

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

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