Need help with COUNTIFS, CONTAINS, AND

Becky M.

I am stumped and cannot find an example. I want to count the cell in range 1 contains the word "flight" and the cell in range 4 on the same row contains the word "enterprise"

This gives #incorrect argument:

=COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), AND({2022 Project List Range 4}, CONTAINS("enterprise", @cell)))

This gives #invalid data type:

=COUNTIFS({2022 Project List Range 1}, "Pushed to 2022", AND({2022 Project List Range 4}, CONTAINS("enterprise")))

Thanks!

Paul Newcome

Your first one is going to be the closest. You just don't need the AND function because it is implied in a COUNTIFS.

=COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), {2022 Project List Range 4}, CONTAINS("enterprise", @cell))

Paul Newcome

Your first one is going to be the closest. You just don't need the AND function because it is implied in a COUNTIFS.

=COUNTIF({2022 Project List Range 1}, CONTAINS("flight", @cell), {2022 Project List Range 4}, CONTAINS("enterprise", @cell))

Becky M.

Thank you @Paul Newcome that worked perfectly beginning with =COUNTIFS

Paul Newcome

Happy to help. 👍️

And that's what I get for copy/pasting and not proofing before posting. Haha. Glad you caught that.