COUNTIF from a multiple drop down, exclude a word using NOT


Hi I'm trying to create a COUNTIF from a multiple drop down but run in to issues as following words are used “Not Accepted” and “Accepted”. I can count the “Not Accepted” by just using (CONTAINS(“Not” but I can’t count only “Accepted” as both “Not Accepted” and “Accepted” will be counted. I did try to use NOT(CONTAINS but without success. 

I get an error on following test. 

=COUNTIFS([RevShare Eligibility]1:[RevShare Eligibility]31; (CONTAINS("Accepted"; NOT(CONTAINS("Not"; @cell)))))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!