Cumulative Count Function

[larryg003]

Hi guys. I am a new member-i had a friend recommend excel forum and he said you guys were very knowledgeable about helping with excel.

I have a (hopefully) quick question
I have a column "M" with 2500 cells of either 0,-1,1. I want to create a column in N, that keeps a cumulative count of the number of times -1 or 1 is reached and resets every time a new value is reached (and disregards the value of 0)
My data starts like this: I want it to say this:
0 0
1 1
1 2
0 0
-1 -1
-1 -2
-1 -3
1 1
1 2
1 3
1 4
1 5
0 0
etc...

Thanks guys I really appreciate all of your help!

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[shg]

Please Login or Register  to view this content.

In N2 and down, =(M2<>0) * (M2 + (M2=M1) * N1)

[larryg003]

THANK YOU SO! YOU GUYS ARE AMAZING! I like RoyUK's suggestion-i will do that from now on. Thanks a lot shg