summing multiple worksheets

How do I make a sheet that tallies the same cell from multiple worksheets?

If the sheets to be added are consecutive (no other sheets are between the
first sheet to be added and the last), use a 3d sum: =sum('First Sheet:Last
Sheet'!a1).
(Replace First Sheet and Last Sheet with your worksheet names.)

"Kamie" wrote:

> How do I make a sheet that tallies the same cell from multiple worksheets?

Hi

Just to add to this suggestion, I like to insert a couple of blanks
sheets into my workbook, and name them First and Last.
Make sure that they are encompassing my range of sheets to be summed,
and my summary sheet is outside of the "sandwich"
Then =SUM(First:Last!A1) becomes a general formula I can use anywhere.
First and Last can be hidden if required

--
Regards

Roger Govier


"bpeltzer" <bpeltzer.deletethissuffix@cox.net> wrote in message
news:C3901B40-33E4-476F-8799-3D25CFD7AC0B@microsoft.com...
> If the sheets to be added are consecutive (no other sheets are between
> the
> first sheet to be added and the last), use a 3d sum: =sum('First
> Sheet:Last
> Sheet'!a1).
> (Replace First Sheet and Last Sheet with your worksheet names.)
>
> "Kamie" wrote:
>
>> How do I make a sheet that tallies the same cell from multiple
>> worksheets?

I've tried that, and It says #REF!

"bpeltzer" wrote:

> If the sheets to be added are consecutive (no other sheets are between the
> first sheet to be added and the last), use a 3d sum: =sum('First Sheet:Last
> Sheet'!a1).
> (Replace First Sheet and Last Sheet with your worksheet names.)
>
> "Kamie" wrote:
>
> > How do I make a sheet that tallies the same cell from multiple worksheets?

thank you roger! for some reason, that worked!!!!!!! yay! i've been trying to
figure this out for about 6 hours!!! much appreciation headed your way!

"Roger Govier" wrote:

> Hi
>
> Just to add to this suggestion, I like to insert a couple of blanks
> sheets into my workbook, and name them First and Last.
> Make sure that they are encompassing my range of sheets to be summed,
> and my summary sheet is outside of the "sandwich"
> Then =SUM(First:Last!A1) becomes a general formula I can use anywhere.
> First and Last can be hidden if required
>
> --
> Regards
>
> Roger Govier
>
>
> "bpeltzer" <bpeltzer.deletethissuffix@cox.net> wrote in message
> news:C3901B40-33E4-476F-8799-3D25CFD7AC0B@microsoft.com...
> > If the sheets to be added are consecutive (no other sheets are between
> > the
> > first sheet to be added and the last), use a 3d sum: =sum('First
> > Sheet:Last
> > Sheet'!a1).
> > (Replace First Sheet and Last Sheet with your worksheet names.)
> >
> > "Kamie" wrote:
> >
> >> How do I make a sheet that tallies the same cell from multiple
> >> worksheets?
>
>
>