Using COUNTIFS to count a single name in a multi select box in a date range

Brett Kennedy

Hi all,

This is my current formula, and it works except that if I have more than the name in the formula also checked in the multi select box it does not count it. How do I change this formula so it counts the name in the multi select box even if there are more than one name selected?

=IF(COUNTIFS(Date:Date, <=Date@row, [End Date]:[End Date], >=Date@row, [Test Staff Column]:[Test Staff Column], "Sample Name") > 1, 1, 0)

Thanks!

Paul Newcome

Try this...

=IF(COUNTIFS(Date:Date, <=Date@row, [End Date]:[End Date], >=Date@row, [Test Staff Column]:[Test Staff Column], CONTAINS("Sample Name", @cell)) > 1, 1, 0)

Paul Newcome

Try this...

=IF(COUNTIFS(Date:Date, <=Date@row, [End Date]:[End Date], >=Date@row, [Test Staff Column]:[Test Staff Column], CONTAINS("Sample Name", @cell)) > 1, 1, 0)

Brett Kennedy

Thanks Paul! that worked

Paul Newcome

Happy to help. 👍️