CountIfs with Date Range on Multi-Select Dropdown

Sean W

I was hoping to be able to find the answer elsewhere but have had no luck. I was able to build the following formula from other answers but stuck on the last part of the criteria (Warning Items) being in a multi-select drop down. So the formula works but is incorrect in that it does not count cells where there is more than one option selected.

=COUNTIFS({HSE Observations Range 3 Audit Date}, <=StartDate@row, {HSE Observations Range 3 Audit Date End}, >=EndDate@row, {HSE Observations Range 2 Warning Items}, [Observation Item]@row)

Could someone help with the solution? Is this even possible? Any help would be appreciated.

Paul Newcome

You will need a HAS function.

HAS(@cell, [Observation Item]@row)

Sean W

@Paul Newcome you sir are awesome. When I posted the message I KNEW it would be you who would provide the solution in a straightforward manner. You have provided so many solutions that I have been able to use.

Thank you very much. 😎

Paul Newcome

You will need a HAS function.

HAS(@cell, [Observation Item]@row)

Sean W

@Paul Newcome you sir are awesome. When I posted the message I KNEW it would be you who would provide the solution in a straightforward manner. You have provided so many solutions that I have been able to use.

Thank you very much. 😎

Paul Newcome

Happy to help. 👍️