adding multiple sheets

T

timastra

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I have a sheet for every month of expenses for my business. What is the easiest way to tally the totals for each category on those sheets into one sheet? Thanks, Tim
 
M

Mike Middleton

Tim -

I don't have an answer for your situation (separate sheets for each month), but if you were starting over, the easiest way might be to keep everything on one sheet in standard database arrangement, i.e., list or table, and then use a pivot table for the summaries.

- Mike
http://www.DecisionToolworks.com
[email protected]


Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I have a sheet for every month of expenses for my business. What is the easiest way to tally the totals for each category on those sheets into one sheet? Thanks, Tim
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

I have a sheet for every month of expenses for my business. What is the
easiest way to tally the totals for each category on those sheets into one
sheet? Thanks, Tim
Click to expand...

If all the monthly sheets are laid out exactly the same, you could do
something like this:

Assume the sheets are named "Jan", "Feb", ... "Dec".

then the totals can be calculated by:

Totals!A1: =SUM('Jan:Dec'!A1)
 
Top