Does it matter if the sheets between Start and End are named other than
sheet2, sheet3, etc? Mine are and I get the dreaded #VALUE? uisng the
=sum(Start:End!A1) method. Thought I understood. Am I supposed to include
the characters "cellref" in there?

The other thing is, if this does work (which I'm sure it will when I get it
right) how does it address the need for daily results getting displayed in
different cells on my summary page?

"Gord Dibben" wrote:

Allewyn

If the total cell on each sheet is same cell you can use

=SUM(Sheet1:Sheet23!cellref)

To allow for inserting more sheets later, I recommend inserting a dummy sheet
named Start at first sheet in book.

Insert a dummy sheet named End at last sheet in book.

Then formula can be =SUM(Start:End!cellref)

New sheets will be inserted between Start and End sheets.


Gord Dibben Excel MVP

On Wed, 21 Dec 2005 09:11:03 -0800, "Allewyn"
wrote:

I have 14 sheets in the workbook
Each sheet has names and numbers and a €˜total calls made cell which I call
from a separate summary sheet
I am tracking calls everyday on the 14 different sheets (different categories)
Yesterday I went through the pain of typing =sum(, click sheet tab, select
cell, +, click next sheet tab, select cell, +, etc.
Yesterday I made 16 calls and the above approach worked great
Today I made 3 calls
Now it doesnt work as great because I want to keep the daily totals
separate on the summary sheet without having to do what I did yesterday.

Column
J2
Row A2 16 Calls yesterday display in A2
3 Calls today
currently 19 displayed on summary sheet from yesterday in
row A2 again, wiping out the prior
number 16
would like to display 3 on summary sheet in a different cell from
the 16 prior calls, such as A4, without having
to go through typing (+, clicking
sheet tab, select cell), (+ clicking
sheet tab, select cell), etc every day.

Is there a way to do this with an automatic update from each sheet to the
summary sheet?