Combining multiple criterias with countifs and has

Mary Kam

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

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

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

Bassam Khalil

@Mary Kam 

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

Bassam Khalil

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

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

Bassam Khalil

@Mary Kam 

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