Countifs formula looks at two columns, multi items in one of the columns

NCharleb

Hi,

Always appreciate your time.

I feel like this shouldn't be hard - end of day eyes maybe?

Column #1 count if a particular Stakeholder name

Column#2 count if Status = "Open" or "Ongoing"

I'm getting errors with these formulas

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "open", Status:Status, "Ongoing")

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "Open", OR(Status:Status, "Ongoing"))

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, "Open", OR,COUNTIF(Status:Status, "Ongoing"))

Jon Mark H

So close @NCharleb !

It's a little funky how it works.

You want to go with:

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, OR(@cell = "Open", @cell = "Ongoing"))

Let me know if that works or if you have any other things you need help with!

-Jon Mark

Jon Mark H

So close @NCharleb !

It's a little funky how it works.

You want to go with:

=COUNTIFS([Primary Stakeholder]:[Primary Stakeholder], "P&T", Status:Status, OR(@cell = "Open", @cell = "Ongoing"))

Let me know if that works or if you have any other things you need help with!

-Jon Mark

NCharleb

Jon, you are my favorite person today - it worked! Thank you!

Jon Mark H

Haha - excellent! Glad I could help!