Combine Index Match with SumIFS (Multiple Criteria)

Conv_Eng

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.

Mike TV

@Conv_Eng

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

Mike TV

@Conv_Eng

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

Conv_Eng

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