SUMIF multiple criteria in other columns

Dayana

Hi! I need help, I am trying to SUMIF the cost for those HC that are "FTE' and Offshore". I am trying this formula, but is not working.

=SUMIFS([Type of HC]1:[Type of HC]40, "FTE", [On/Offshore]1:[On/Offshore]40, "Onshore", [FY22 P1 July]1:[FY22 P1 July]40)

Thank you!

Paul Newcome

The syntax for SUMIFS is different from the SYNTAX for SUMIF. Since you are using SUMIFS you need to enter the range to sum FIRST then follow it with your range/criteria sets.

Paul Newcome

The syntax for SUMIFS is different from the SYNTAX for SUMIF. Since you are using SUMIFS you need to enter the range to sum FIRST then follow it with your range/criteria sets.

Dayana

Thank you for your help, it worked perfect!

Paul Newcome

Happy to help. 👍️