View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Django Cat Django Cat is offline
external usenet poster
 
Posts: 4
Default 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