Combining multiple criterias with countifs and has

Question

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.

Bassam Khalil · Accepted Answer

Hi @Mary Kam

Please try the following formula:

=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}, "")

Mary Kam · Accepted Answer

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

Bassam Khalil · Accepted Answer

@Mary Kam

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