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
-
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.
Answers
-
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.
-
Thank you for your help, it worked perfect!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!