COUNTIFS Help - what is wrong with my formula

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

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")))

Answers

  • Swap your value and range around. Sample Usage:

    IF(CONTAINS("Jacket", [Clothing Item]:[Clothing Item]), "True", "False")

    Try this:

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

Sign In or Register to comment.