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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives