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
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives