K
Kamie
How do I make a sheet that tallies the same cell from multiple worksheets?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bpeltzer
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.)
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.)
R
Roger Govier
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
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
K
Kamie
I've tried that, and It says #REF!
bpeltzer said: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.)
K
Kamie
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!
figure this out for about 6 hours!!! much appreciation headed your way!