Stuck on a formula for a multi-drop down
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!
Best Answer
-
Try this:
=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, HAS(@cell, "Strategy"))
Answers
-
Try this:
=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, HAS(@cell, "Strategy"))
-
That's worked! Thanks so much Paul
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!