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

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

Brilliant! Thanks Art, that works perfectly.

DC

On 25 May, 16:28, Art Caragh
wrote:
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- Hide quoted text -

- Show quoted text -