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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Formula For Summing Range
This one stumped me, too until i realized that I could use the SUBTOTAL
function instead of SUM in my formula. It has the added benefit of automatically outlining my data so that when collapsed, I could autofill my formula down to only the subtotaled rows "Timmy Mac1" wrote: 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 |
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 | |||
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 |