Sum Data based on Multiple Conditions across Multiple Sheets

[TP8041]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Code # 1 thru 10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hrs 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hrs 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hotel[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Meals[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Misc[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Miles[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Based on the Code # I need to be able to total Each of the other data across multiple sheets (50+). Each Sheet contains a group of 6 entries of the data as shown.

 

[tcardwell]

Hello,

I'm assuming you have 50+ sheets is because each sheet has a unique name attached to it. Why not just create one sheet, one table and add an extra column to hold what is the sheet name? Summing data in tables is orders of magnitude easier than having to deal with 50+ worksheets.

Tom C

 

[TP8041]

Thank You for your input,

I have 1 Workbook with roughly 25+ sheets. Each sheet is a basic time sheet with 6 entries containing the data as listed. I am wanting to make a Totals Sheet that will Total data per the appropriate accounting Code# 1 thru 10. The formula would look at all sheets current and future, compile totals in the same format as listed per each accounting Code#.

TP

 

[TP8041]

Sorry, more info: Each sheet can have up to 6 different Code# & the additional listed data.

TP