Counting contents in aray

[jpreman]

Thanks for reading this post.

One in each cell, there are several alphabets in a range of cells (eg. A1
:C10). I would like to know the combined count of alphabets "A" and "L". How
can I achieve this?

Tks

Preman

 

[Bob Phillips]

=SUM(COUNTIF(A1:C10,{"A","L"}))

 

[Gary''s Student]

=COUNTIF(A1:C10,"A")+COUNTIF(A1:C10,"L")

 

[jpreman]

Thanks Bob,

You have taught me a different (better) solution than the one I figured out
within minutes of posting my question.

Kind regards

Preman

 

[jpreman]

Hi

Thanks for responding to my post. That's exactly what I was looking for.

Kind regards

Preman

 

[jpreman]

Hi Bob,

I would be thankful if you kindly explain how curly brackets work in formulas.

Thanks & regards

Preman

 

[Bob Phillips]

Hi Preman,

The curly brackets signify an array constant, an array of values that will
be used within the formula. For instance, COUNTIF normally checks a range
against a particular value. If you use an array constant rather than a
particular value, COUNTIF will return an array of values equivalent to
multiple COUNTIF calls. The SUM is needed to sum this array returned by the
COUNTIF.

 

[jpreman]

That's great.

Thanks a million Bob.

Kind regards

Preman