Counting occurances in a cell

[Welsh Mark]

Is there a formula that can tell me how many time all the occurances appear in a column?

Example
Column A Column B
Mark 2
John 1
Mark 2
Steve 1
Jo 1
Lewis 1
Aaran 3
Aaran 3
Aaran 3

 

[VoG]

Maybe

=COUNTIF(A1:A10,"Aaran")

or perhaps you mean

=SUMIF(A1:A10,"Aaran",B1:B10)

 

[hallingh]

What do you mean by occurances?

Could you give me just a bit more detail?

Hank

 

[hallingh]

Maybe you mean this?

=COUNTIF($A$1:$A$10,A1)

Click and drag it down to the cells you want and alter the range accordingly.

Hank

 

[Welsh Mark]

Column A contains about 50 different codes. But my spread sheets contaiins over 300'000 records. But I need to count how many times a code appears. I was hoping a formula would be able to help me rather than using a filter and counting each code.

 

[hallingh]

Yea, I think mine will work for that. Just alter the range referenced to reflect the range you want it to look at.