automated continuous adding

  • Thread starter Thread starter highbeef
  • Start date Start date
H

highbeef

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
 
How about just using extremely large rows?

=subtotal(3,c3:c65536)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top