adding multiple sheets

[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

 

[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
(e-mail address removed)


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

 

[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

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('Janec'!A1)