Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.worksheet.functions




how to auto increment cell location within formula
forgive me if this is basic stuff but I am trying to figure out the
following: have 2 columns of numbers say C and D where I need a running total starting at say D4 with the formula=SUM(C4C3) then D5 would be SUM(C5C4); then D6 SUM(C6C5) and so on. Is there a way to automate this? Thanks  Bill 
#2
Posted to microsoft.public.excel.worksheet.functions




how to auto increment cell location within formula
Hi!
Just enter this formula in D4: =C4C3 Now, just drag copy down the column and the cell references will automatically increment. Biff "Bill" wrote in message oups.com... forgive me if this is basic stuff but I am trying to figure out the following: have 2 columns of numbers say C and D where I need a running total starting at say D4 with the formula=SUM(C4C3) then D5 would be SUM(C5C4); then D6 SUM(C6C5) and so on. Is there a way to automate this? Thanks  Bill 
#3
Posted to microsoft.public.excel.worksheet.functions




how to auto increment cell location within formula
Hi Bill, are you referring to Autofill? Once you have a relative cell
reference in (without $ signs) as in your example, you move your mouse to the lower right hand corner of that cell and your cursor turns from white cross hair to a black crosshair, leftclick and hold, drag it down as far as you need it to go. HTH, Kevin M "Bill" wrote: forgive me if this is basic stuff but I am trying to figure out the following: have 2 columns of numbers say C and D where I need a running total starting at say D4 with the formula=SUM(C4C3) then D5 would be SUM(C5C4); then D6 SUM(C6C5) and so on. Is there a way to automate this? Thanks  Bill 
#4
Posted to microsoft.public.excel.worksheet.functions




how to auto increment cell location within formula
thanks  worked great; I thought I tried this yesterday but apparently
botched it. Bill Biff wrote: Hi! Just enter this formula in D4: =C4C3 Now, just drag copy down the column and the cell references will automatically increment. Biff "Bill" wrote in message oups.com... forgive me if this is basic stuff but I am trying to figure out the following: have 2 columns of numbers say C and D where I need a running total starting at say D4 with the formula=SUM(C4C3) then D5 would be SUM(C5C4); then D6 SUM(C6C5) and so on. Is there a way to automate this? Thanks  Bill 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Match then lookup  Excel Worksheet Functions  
Formula Problem  interrupted by #VALUE! in other cells!?  Excel Worksheet Functions  
How do I set a cell value based on a formula in another cell?  Excel Discussion (Misc queries)  
Formula checking multiple worksheets  Excel Worksheet Functions  
looking for a formula  Excel Worksheet Functions 