Sum If Help

Elizabeth Jones

I'd like to sum the number of story points if "label" = "Unity_Beta"

Then sum the number of story points if the "label" = "Unity_Beta" and the "Status" = done

Paul Newcome

For the second part:

=SUMIFS([Story Points]:[Story Points], Labels:Labels, "Unity_beta", Status:Status, "Done")

Paul Newcome

My apologies. I forgot to take out the first "In Progress".

=SUMIFS([Story Points]:[Story Points], [Fix Versions]:[Fix Versions], "Unity Beta Migration", [Status]:[Status], OR(@cell = "PR (develop)", @cell = "In Progress"))

Andrée Starå

Hi Elizabeth,

Try something like this.

=SUMIF(Labels:Labels; "Unity_beta"; [Story Points]:[Story Points])

The same version but with the below changes for convenience.

=SUMIF(Labels:Labels, "Unity_beta", [Story Points]:[Story Points])

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

For the second part:

=SUMIFS([Story Points]:[Story Points], Labels:Labels, "Unity_beta", Status:Status, "Done")

Andrée Starå

@Elizabeth Jones Apologies, I missed the second part!

@Paul Newcome Thanks!

Paul Newcome

@Andrée Starå 👍️

Elizabeth Jones

Is it possible to do look for two status "PR (develop)" or "In Progress" ?

=SUMIFS([Story Points]:[Story Points], [Fix Versions]:[Fix Versions], "Unity Beta Migration", [Status]:[Status], "In Progress", OR "PR (develop)

getting an error...maybe a misplaced comma?

Paul Newcome

=SUMIFS([Story Points]:[Story Points], [Fix Versions]:[Fix Versions], "Unity Beta Migration", [Status]:[Status], "In Progress", OR(@cell = "PR (develop)", @cell = "In Progress"))

Give something like that a try...

Elizabeth Jones

hmm I'm getting "invalid" as the response

Paul Newcome

My apologies. I forgot to take out the first "In Progress".

=SUMIFS([Story Points]:[Story Points], [Fix Versions]:[Fix Versions], "Unity Beta Migration", [Status]:[Status], OR(@cell = "PR (develop)", @cell = "In Progress"))