Using COUNTIFS to count a single name in a multi select box in a date range
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)
Help Article Resources
Check out the Formula Handbook template!