SUMIF multiple criteria in other columns

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!