Hi everyone...

I need to figure out how to create a new variable that is a cumulative
sum of an existing variable with conditions. an example is below where
sumnumber is what i am trying to create. any help would be appreciated.
thanks.



subject visit number sumnumber
1000 1 5 5
1000 3 6 11
1000 4 2 13
1000 7 4 17
2000 1 0 0
2000 2 2 2
2000 3 0 2
3000 4 5 5
4000 1 2 2
4000 4 2 4


--
chiapas77
------------------------------------------------------------------------
chiapas77's Profile: http://www.excelforum.com/member.php...o&userid=30568
View this thread: http://www.excelforum.com/showthread...hreadid=502153