Grand Total

  • Thread starter Thread starter dstarr
  • Start date Start date
D

dstarr

I want to add up the total for a whole Column and get the subtotal a
the bottom. I also want ot be able to add entries when I want. When
try this I can't add new entries as the grand total is in thw way.

Thank
 
You could move the total to the top of the column, or use Data>Subtotals
to display totals when required.
 
I like to put the totals (=sum() or =subtotal()) in row 1.
I put headers in row 2 (with autofilters).
I freeze panes so that rows 1&2 are always visible.

Then I never have to adjust my formulas--I use a range way to big for what I
really need!

=sum(a3:a9999)

But if you want, you can change your sum formula to point at the cell above:

I wanted the sum in A30 (a2:a29 right now):

In A30:
=SUM(A2:OFFSET(A30,-1,0))
 
Back
Top