Stuck on a formula for a multi-drop down

K Ops

Hi everyone,

I'm using sheet summary to count various formulas for me and I'm stuck on the below. I need to count all rows that have "Strategy" in the Channel column, whether it's the only entry or one of several.

I've tried variations using HAS or CONTAINS but it still doesn't work.

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, "Strategy")

Thanks in advance!

Paul Newcome

Try this:

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, HAS(@cell, "Strategy"))

Paul Newcome

Try this:

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, HAS(@cell, "Strategy"))

K Ops

That's worked! Thanks so much Paul

Paul Newcome

Happy to help. 👍️