The solution is to use the Countif function

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

Hope this is helpful

"Django Cat" wrote:

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