Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding formula
I am trying to complete a formula that will enable me to do the following.
D4 = C3 + C4 D5 = C4 + C5 So the total in the D columnis the addition of the new C column total. example: B C D 10+10 20 20 <-- 20+10 30 50 <-- these is a running totals 5+15 20 70 <-- etc The formula would be placed in the D column and would remain empty if the C column is empty. Thanks in advance. Scoober |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding formula
Enter this formula in D3 and copy down as needed:
=IF(C3="","",SUM(C$3:C3)) -- Biff Microsoft Excel MVP "Scoober" wrote in message ... I am trying to complete a formula that will enable me to do the following. D4 = C3 + C4 D5 = C4 + C5 So the total in the D columnis the addition of the new C column total. example: B C D 10+10 20 20 <-- 20+10 30 50 <-- these is a running totals 5+15 20 70 <-- etc The formula would be placed in the D column and would remain empty if the C column is empty. Thanks in advance. Scoober |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding to formula | Excel Discussion (Misc queries) | |||
Adding to a formula | Excel Discussion (Misc queries) | |||
Adding on to a formula | Excel Worksheet Functions | |||
adding a formula | Excel Discussion (Misc queries) | |||
Formula help : adding | New Users to Excel |