# Combine Index Match with SumIFS (Multiple Criteria)

Options
✭✭✭

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.

• ✭✭✭✭✭✭
Options

=SUMIFS({Sheet 2 Hours Used}, {Sheet 2 Project Number}, [Project Number]@row, {Sheet 2 Labor Code}, [Labor Code]@row)

• ✭✭✭✭✭✭
Options

=SUMIFS({Sheet 2 Hours Used}, {Sheet 2 Project Number}, [Project Number]@row, {Sheet 2 Labor Code}, [Labor Code]@row)

• ✭✭✭
Options

Thanks, Mike TV. That did the trick. I appreciate the help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!