Counting similar occurrences... how??

  • Thread starter Thread starter theMusicMan
  • Start date Start date
T

theMusicMan

Hello All

My first post here.... :)

I am simply trying to count the number of similar occurrences of data
items within a column. i.e. if the column comprises...

1
1
1
2
2
3
3
3
3

... then I want to calculate the number of times the number 1 appears,
the number 2 appears etc etc.. .so the answer in this case is;

1=3
2=3
3=4

Is there an Excel function to achieve this...?
 
Hi
COUNTIF is the function you're looking for. If your data is in column A
try:
=COUNTIF(A:A,1)
=COUNTIF(A:A,2)
=COUNTIF(A:A,3)

for the number of occurences for 1, 2 and 3 in column A
Frank
 
Back
Top