Counting cells with multiple selections and criteria

Lisa Wills

HI- I'm trying to count the cells for the developer (1st criteria) and priority (2nd criteria) which sometimes has multiple selections. It is only pulling counts for those cells that have one option selected.

I need for it to pull counts for the developer even when there are more than one priority selected in 2nd criteria range.

Here's what I have so far. Thanks for your help!

Paul Newcome

Try this...

=COUNTIFS({Developer}, "Yvette Wilkins", {Range 2}, CONTAINS("P1: Broken.....", @cell))

Lisa Wills

Thank you!

Paul Newcome

Try this...

=COUNTIFS({Developer}, "Yvette Wilkins", {Range 2}, CONTAINS("P1: Broken.....", @cell))

Lisa Wills

Thank you!

Paul Newcome

Happy to help. 👍️