Count Data Based on Values in 2 columns



I am trying to input a formula to count data in a column if certain criteria are not met in another column. I cannot seem to get it right. This is what I have:

=COUNTIFS({Qty. Res. Planner 2023 Range 1} CONTAINS("I", @cell)), AND{Qty. Res. Planner 2023 Jan 22} NOT(CONTAINS("OUT", @cell)))

I have data in column 1 and column January. I want the value returned when there is an "I" in column 1 and when column January doesnt say OUT. Based on table below it should be 3.

Thank you,



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!