Counting with zero between it and start over if..

Count how many times you buy something, without selling it
The difficult part is that there are also zero values between it
So you buy at A2, A7 and A11. And then at B11 you sell something.
So you count at C2 is1 at A7 is 2 and A 11 is 3

Every time you buy something you have to count how many times you bought something without selling it.

If you sold something you are going to start all over. So at A12 you start over with counting, this one you sell so is only 1

At A14 you are going to start all over with counting till A24
The right asnwers are in column C but I have to automate it for a really large sheet
Can someone please help me!

I was thinking the answer would be something like this:

=SUM($A$2:A2)-SUM($B$2:B2) in C2 copied down

but it doesn't fit in with your example and having read it half a dozen times I really don't get it. How come if you have bought 3 and sold 1 the count is 3?

Dom

Using your posted example, try this:

C2: =IF(A2,A2,"")

and use this regular formula for the rest

Please Login or Register  to view this content.

Copy that formula down as far as you need.

Is that something you can work with?