software

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: www.excelforum.com/member.php...oamp;userid=15188
View this thread: www.excelforum.com/showthread...hreadid=504523This 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

quot;Timmy Mac1quot; wrote:

gt;
gt; I need a macro that will sum the cells immediately above at various
gt; places on the worksheet.
gt;
gt; Sometimes this might involve summing two cells, sometimes twenty. But
gt; the groups of cells run under each other so that for example in A3 I
gt; might need sum(A1,A2) whereas then in A10 I'll need the sum (A4.A7).
gt;
gt; Is there anyway of doing this?
gt;
gt;
gt; --
gt; Timmy Mac1
gt; ------------------------------------------------------------------------
gt; Timmy Mac1's Profile: www.excelforum.com/member.php...oamp;userid=15188
gt; View this thread: www.excelforum.com/showthread...hreadid=504523
gt;
gt;