| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Making a formula continuous
I have the formula =SUM(K$5:K10)/5. I need the next cell down to have the formula =SUM(K$5:K11)/6 and then the next down =SUM(K$5:K12)/7 and so on. The problem I have is getting the last number to add by 1 each time, without typing it in by hand. Does anyone know how to do this. Any help would be greatly appreciated. -- Neil_Pattison ------------------------------------------------------------------------ Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696 View this thread: http://www.excelforum.com/showthread...hreadid=474141 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| writing a formula for a colored value | New Users to Excel | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Cease Excel's "formula making" | Excel Discussion (Misc queries) | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
