Counting differing items

[Django Cat]

Hi Folks

In a column I have three possible values, A, B or C.

I'd like to be able to construct formulas which count the number of
times each value occurs, so that I could then have three cells showing
total occurances of A, total occurances of B and total occurances of
C.

I've tried to get COUNTA to do this, but without success.

TIA

DC

 

[Art Caragh]

The solution is to use the Countif function

e.g.=countif(A1:A100,"A")

Hope this is helpful

 

[Django Cat]

Brilliant! Thanks Art, that works perfectly.

DC

The solution is to use the Countif function

e.g.=countif(A1:A100,"A")

Hope this is helpful








- Show quoted text -