Need help with COUNTIFS, CONTAINS, AND

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!