automated continuous adding
 

Hi
i have 2 columns. one column outgoings, one column incomings.
at the top of the page i also have subtotals for these columns.
The problem is that i have to keep changing the cell numbers of th
subtotals because new values are added to the columns and therefor
make them longer.
How do i automate this procedure??

Any help would be greatly appreciated

--
highbee
-----------------------------------------------------------------------
highbeef's Profile: http://www.excelforum.com/member.php...fo&userid=1616
View this thread: http://www.excelforum.com/showthread.php?threadid=27595

automated continuous adding
 

How about just using extremely large rows?

=subtotal(3,c3:c65536)




highbeef wrote:

Hi
i have 2 columns. one column outgoings, one column incomings.
at the top of the page i also have subtotals for these columns.
The problem is that i have to keep changing the cell numbers of the
subtotals because new values are added to the columns and therefore
make them longer.
How do i automate this procedure??

Any help would be greatly appreciated.

--
highbeef
------------------------------------------------------------------------
highbeef's Profile: http://www.excelforum.com/member.php...o&userid=16167
View this thread: http://www.excelforum.com/showthread...hreadid=275953

--

Dave Peterson