COUNTIFS Help - what is wrong with my formula

Can anyone tell me what is wrong with this?

I am trying to count all the cells in column "Monday" that does not contain the word hold (case doesn't matter but I haven't gotten that far) where the cell in the same row in the column Description contains LIRR.

I get the error "Incorrect Argument Set"


=COUNTIFS([Monday]3:[Monday]86, NOT(CONTAINS(("Hold")), Description3:Description86, CONTAINS("LIRR")))

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!