SUMIFS and NOT

Hello,

I'm receiving an error in the below formula. Not sure if I'm using the "NOT" correctly here. I want to sum all the story points for all "Small" projects, but exclude projects where the phase is in "Backlog" or "Pause/On-Hold."

=SUMIFS({Planning Story Pts}, {Project Size}, "Small", NOT({Team Phase}, "Backlog", "Pause/On-Hold"))

Thanks,

Amy

Find more posts tagged with

Accepted answers

All comments

Sameer Karkhanis

Try this:

=SUMIFS({Planning Story Pts}, 
	{Project Size}, "Small", 
	{Team Phase}, AND(@cell <> "Backlog", @cell <> "Pause/On-Hold")
	)

Or

=SUMIFS({Planning Story Pts}, 
	{Project Size}, "Small", 
	{Team Phase}, NOT(OR(@cell = "Backlog", @cell = "Pause/On-Hold"))
	)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.