Combine Index Match with SumIFS (Multiple Criteria)


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!