Mike H;253207 Wrote:
Hi,

This assumes the first sheet is 2009 and the last 2019 and all the
other
sheet are between those 2 sheets

= SUM('2009:2019'!A1)

Mike

"Vic" wrote:

my workbook consist of 10 one year expense tabs 2009 thru 2019 and a
summary
tab.
i want the summary tab to tally the calender year expense as i copy
the
summary tab from year to year. Every year tab uses the exact same
cell from
year to year. the only difference is the the tab 2009, 2010, 2011,
etc

If you're not sure of your syntax select the cell were the formula
should be
Enter =sum(
Click the cell you want to sum
While pressing the shift key select the last tab you need.
Add the closing parenthesis
Done


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=70701