Macro Formula For Summing Range

T

Timmy Mac1

I need a macro that will sum the cells immediately above at variou
places on the worksheet.

Sometimes this might involve summing two cells, sometimes twenty. Bu
the groups of cells run under each other so that for example in A3
might need sum(A1,A2) whereas then in A10 I'll need the sum (A4.A7).

Is there anyway of doing this
 
K

KimC

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
 
Top