Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cummulative sum
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cummulative sum
Try =IF(A1=A2,D1+C2,C2) copied down Where A1=Subject title, A2=first entry C1=Number title, C2=first entry And D2 is where you star entering your data. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=502153 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cummulative sum
Assuming that subject is sorted as your example shows:
D2: =C2 D3: =IF(A3=A2,D2+C3,C3) copy D2 down as far as necessary. In article , chiapas77 wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cummulative sum
seemed to work pretty good. thanks. -- chiapas77 ------------------------------------------------------------------------ chiapas77's Profile: http://www.excelforum.com/member.php...o&userid=30568 View this thread: http://www.excelforum.com/showthread...hreadid=502153 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference | Excel Worksheet Functions |