Counting contents in aray

J

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
 
J

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
 
J

jpreman

Hi

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

Kind regards

Preman
 
J

jpreman

Hi Bob,

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

Thanks & regards

Preman
 
B

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.
 
Top