Counting differing items
 

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

Counting differing items
 

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

Counting differing items
 

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 -