Bottom total row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi--I have a "totals" row at the bottom of my spreadsheet, but am continually adding new rows to the sheet. Is there a way to keep the totals row at the bottom, without overrunning it with newly inputted data

Thanks!
 
Why not just have it at the top? You can then use various formulas to ensure
that all the data gets picked up in the totals, regardless of how many rows of
data there.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



tdp said:
Hi--I have a "totals" row at the bottom of my spreadsheet, but am continually
Click to expand...
adding new rows to the sheet. Is there a way to keep the totals row at the
bottom, without overrunning it with newly inputted data?
 
Assuming it is in A100

=SUM(A1:OFFSET(A100,-1,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

tdp said:
Hi--I have a "totals" row at the bottom of my spreadsheet, but am
Click to expand...
continually adding new rows to the sheet. Is there a way to keep the totals
row at the bottom, without overrunning it with newly inputted data?
 
Because my boss wants it at the bottom :)

----- Ken Wright wrote: ----

Why not just have it at the top? You can then use various formulas to ensur
that all the data gets picked up in the totals, regardless of how many rows o
data there

--
Regard
Ken....................... Microsoft MVP - Exce
Sys Spec - Win XP Pro / XL 00/02/0

---------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-
---------------------------------------------------------------------------



tdp said:
Hi--I have a "totals" row at the bottom of my spreadsheet, but am continuall
Click to expand...
adding new rows to the sheet. Is there a way to keep the totals row at th
bottom, without overrunning it with newly inputted data
 
Put a couple of blank rows above the total row, protect that row so that it will
give an error message if someone tries to imput over top

: Because my boss wants it at the bottom :) !
:
: ----- Ken Wright wrote: -----
:
: Why not just have it at the top? You can then use various formulas to
ensure
: that all the data gets picked up in the totals, regardless of how many
rows of
: data there.
:
: --
: Regards
: Ken....................... Microsoft MVP - Excel
: Sys Spec - Win XP Pro / XL 00/02/03
:
: -------------------------------------------------------------------------
---
: It's easier to beg forgiveness than ask permission :-)
: -------------------------------------------------------------------------
---
:
:
:
: : > Hi--I have a "totals" row at the bottom of my spreadsheet, but am
continually
: adding new rows to the sheet. Is there a way to keep the totals row at
the
: bottom, without overrunning it with newly inputted data?
: >> Thanks!
:
:
: ---
: Outgoing mail is certified Virus Free.
: Checked by AVG anti-virus system (http://www.grisoft.com).
: Version: 6.0.588 / Virus Database: 372 - Release Date: 13/02/2004
:
:
:
 
By the way, if you feel confident about your position , suggest it to your
boss. It shows that you are not just a yes-man, and that you have ideas. You
might just get a raise (or fired!)

Bob
 
Hi, Bob--I tried that formula in the appropriate cell, but the row still got overwritten

I put a "protection" label on it as Layla suggested above to prompt me to not overwrite the totals row

Thanks

----- Bob Phillips wrote: ----

Assuming it is in A10

=SUM(A1:OFFSET(A100,-1,0)

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

tdp said:
Hi--I have a "totals" row at the bottom of my spreadsheet, but a
Click to expand...
continually adding new rows to the sheet. Is there a way to keep the total
row at the bottom, without overrunning it with newly inputted data
 
Back
Top