SUMIFS and NOT

Amy Evans

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

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"))
	)