COUNTIFS AND HAS functions for Multiple values

che.rabajante

Hello,

Need help on this, I need to get the total number per tasks and status in Summary Sheet, resource is Sample Data.

Tasks, Assigned Office, Assigned Field (in Sample Data sheet) has multiple values

Thank you!

che.rabajante

Already got this😀

Genevieve P.

Hi @che.rabajante

I'm glad you were able to figure this out! I assume you added multiple COUNTIFS functions together, is that correct?

E.g:

=COUNTIFS({column 1}, HAS(@cell, "Value 1"), {column 2}, HAS(@cell, "Value 1")) + COUNTIFS({column 1}, HAS(@cell, "Value 2"), {column 2}, HAS(@cell, "Value 2"))