2 Column Criteria
I am getting a "#Incorrect Argument Set" for the following:
=SUMIF([Division & APC]1:[Division & APC]50, "FOP Crew Mobility", [# of Features]1:[# of Features]50, >=1)
=SUMIFS([Division & APC]1:[Division & APC]50, "FOP Crew Mobility", [# of Features]1:[# of Features]50, >=1)
I'm trying to capture: If column 1 has "FOP Crew Mobility" then sum the total # of Features in column 2 if an item is greater than or equal to 1. Any ideas?
Answers
-
Hey @tmkj20
The SUMIFS syntax is not what smartsheet is expecting. Try this
=SUMIFS([# of Features]1:[# of Features]50, [Division & APC]1:[Division & APC]50, "FOP Crew Mobility", [# of Features]1:[# of Features]50, >=1)
If you do not specifically need the range from rows 1 to 50 called out, you can make the formula more robust by removing all references to the row numbers in all range groups.
Will the formula above work for you?
Kelly
-
Hi Kelly:
Thank you for the quick response! I'm just seeing today! The solution I created was:
=SUMIF([Division & APC]:[Division & APC], "FOP Crew Mobility", [# of Features]:[# of Features])
But, I tested your suggestion as well and it worked! Thank you so much!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives