Combine Index Match with SumIFS (Multiple Criteria)
Hello,
I am having trouble figuring out how to calculate a sum if multiple criteria are met. I am referencing data between two sheets. I want to test if there is a match for two criteria in 'Sheet 1' (Project Number and Labor Code) against those same criteria in 'Sheet 2'. If both criteria are met, I would like to sum all of the values from a column in sheet 2 ('Hours Used') that meets both criteria. In this example, the answer should be 10 (Project Number 12345 & Labor Code 4321). Any help would be appreciated.
Best Answer
-
=SUMIFS({Sheet 2 Hours Used}, {Sheet 2 Project Number}, [Project Number]@row, {Sheet 2 Labor Code}, [Labor Code]@row)
Answers
-
=SUMIFS({Sheet 2 Hours Used}, {Sheet 2 Project Number}, [Project Number]@row, {Sheet 2 Labor Code}, [Labor Code]@row)
-
Thanks, Mike TV. That did the trick. I appreciate the help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!