Combining multiple criterias with countifs and has

Options
✭✭✭✭

I would like to simplify my formula

=COUNTIFS({WK 24 Range 1}, HAS("5:00", @cell), {WK 24 Range 2}, "") + COUNTIFS({ WK 24 Range 1}, HAS("5:15", @cell), {WK 24 Range 2}, "") + COUNTIFS(WK 24 Range 1}, HAS("5:30", @cell), {WK 24 Range 2}, "") + COUNTIFS({ WK 24 Range 1}, HAS("5:45", @cell), { WK 24 Range 2}, "")

Is there a way to get the formula to have multiple criterias 5:00, 5:15,5:30,5:45 all together.

• ✭✭✭✭✭✭
Options

Hi @Mary Kam

=COUNTIFS({WK 24 Range 1}, OR(HAS("5:00", @cell), HAS("5:15", @cell), HAS("5:30", @cell), HAS("5:45", @cell)), {WK 24 Range 2}, "")

bassam.khalil2009@gmail.com

• ✭✭✭✭
Options

Thank you so much for the prompt reply. The formula worked perfectly, and will make my work more efficient.😁😁😁

• ✭✭✭✭✭✭
Options

You are welcome and I will be happy to help you any time.

bassam.khalil2009@gmail.com

• ✭✭✭✭✭✭
Options

Hi @Mary Kam

=COUNTIFS({WK 24 Range 1}, OR(HAS("5:00", @cell), HAS("5:15", @cell), HAS("5:30", @cell), HAS("5:45", @cell)), {WK 24 Range 2}, "")

bassam.khalil2009@gmail.com

• ✭✭✭✭
Options

Thank you so much for the prompt reply. The formula worked perfectly, and will make my work more efficient.😁😁😁

• ✭✭✭✭✭✭