Sum Data based on Multiple Conditions across Multiple Sheets

TP8041

New Member
Joined
Dec 10, 2018
Messages
3
Code # 1 thru 10
Hrs 1
Hrs 2
Hotel
Meals
Misc
Miles

<tbody>
</tbody>


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.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

tcardwell

Board Regular
Joined
Dec 22, 2013
Messages
84
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

New Member
Joined
Dec 10, 2018
Messages
3
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

New Member
Joined
Dec 10, 2018
Messages
3
Sorry, more info: Each sheet can have up to 6 different Code# & the additional listed data.

TP
 

Watch MrExcel Video

Forum statistics

Threads
1,099,029
Messages
5,466,116
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top