can excel count each cell in a row & stops at point then re counts

[peterpan1233]

HI

can excel count each cell in a row & stops at point then re counts, I have tried all the count A (count if, only counts all at once) this is what I am trying to do:
count how many times the 233 stock code sold in a row, thank you in advance for any help

row below . = this is what answer i am looking for

233 =1 counts 1 on its own

0 =1 = counts 1 on its own

233 = 1

233 = 2 = counts 2 in a row together

0 = 1

0 = 2

0 = 3 = counts 3 in a row together

[Fluff13]

Hi & welcome to the board.
How about

Please Login or Register  to view this content.

[peterpan1233]

not sure if I'm doing this right? it gave me this : can you please explain what # i click for A1 A2 & B1, i clicked A1 for 233 A2 for 0 and 0 for B1, is that right? Thank you
233 1
0 1
0 1
0 1
233 234
233 1
0 1
233 234
233 234
233 234
233 1
0 1
0 1

[Fluff13]

The formula goes in B2 copied down to give
Excel 365 (Windows) 32 bit

	A	B
1	Numbers	Count
2	233	1
3	0	1
4	233	1
5	233	2
6	0	1
7	0	2
8	0	3

Sheet: Lists

[peterpan1233]

i wish i knew how you got it to do that. I've tried many times and i keep getting different answers, it wont do the 1 2 3 like yours, what am i doing wrong?

[Fluff13]

Please upload a sample workbook, look at the yellow banner at the top of the site for instructions.

[JohnTopley]

Example in attached

See column B