| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Formula For Summing Range
I need a macro that will sum the cells immediately above at various places on the worksheet. Sometimes this might involve summing two cells, sometimes twenty. But the groups of cells run under each other so that for example in A3 I might need sum(A1,A2) whereas then in A10 I'll need the sum (A4.A7). Is there anyway of doing this? -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=504523 |
| 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 | |||
| Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Threaded Mode
