SUMIFS Formula
Novice Smartsheet User
Trying to calculate the Sum of the numbers in a Column with Conditions from 2 other Columns. I keep getting the #UNPARSEABLE error.
Condition: Sum up the numbers in Story Points when the "Sprint Name" column matches a certain value and "Team" column data matches a certain value. Both "Sprint Name" and "Team" fields are Text fields.
Please check the formula I used:
=SUMIFS(Story Points:Story Points, [Sprint Name]:[Sprint Name], "Sprint 15", [Team]:[Team], "INS")
Comments
-
Hi Sree,
Looks like your first column range is missing the square brackets, try this:
=SUMIFS([Story Points]:[Story Points], [Sprint Name]:[Sprint Name], "Sprint 15", [Team]:[Team], "INS")
Any column name that has spaces or ends in numbers/symbols needs to have square brackets around it.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives