Summing Across Multiple Sheets

**nawas** · 12-01-2009, 04:08 AM

Hi,

I'm looking for a summary report which summing multiple sheets as per the criteria. Which means I've monthly Business Expenses sheets for different employees, what i need is summary report for each employee against the total cost.

Attached the sample spread sheet for your kind review.

Your support would be highly appreciated

**teylyn** · 12-01-2009, 04:21 AM

Hi,

you may not like this, but ....

You'd make your life a lot easier if you collected all the data in a single sheet, instead of one sheet for each month.
Then you could use a pivot table to sum/slice/dice/categorise by person and time frame.

This would be a lot easier than starting with a (bad (sorry, but true)) spreadsheet design and trying to tack on complicated formulae to enable reporting that could have been simple from the get-go.

check out how to get started with pivot tables here:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

hth