keeping a running count

[leo002000]

Dear forum,

I have a spreadsheet that has numbers in column A (example = 31, 15, 159) I want to count the number (159) each time it occurs and keep a running count of it in say column B... example..... A1 = 159, A2 = 31, A3 = 159, so B3 would show (2) as the number 159 has appeared 2 times thus far...

Any help would be greatly appreciated.

[martindwilson]

=countif(a:a,159)

[zbor]

Like this?

Put in B1
=COUNTIF($A$1:A1,A1)

and extend down

or for previous too:

=COUNTIF(A:A;A1)

[leo002000]

Many thanks for your swift reply, and advice...

I ended up using =IF(A2=$K$2,COUNTIF($A$2:A2,$K$2),"")

K2 = 159 and the if function removed the counting whilst the cell in column A did not have 159 (K2) in it... so now I only get the count when 159 (k2) appears...

Many thanks, you put me on the right tracks, I am having a brain dead day I think.

Best wishes

Leo