Counting rows with value in a column, but exclude rows with a value in a different column


Hi All,

This may seem pretty straight-forward, but I'm having a block.

I'm trying to create a sheet with some summary info from another sheet. I am trying to get the count of rows where the value in the name column matches a cell in my sheet, but exclude rows where another column contains a different value. Something like:

=COUNTIFS({Reports Names}, CONTAINS(Name@row), {Reports Week}, NOT(CONTAINS("result"})))

Any help would be appreciated!

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Answer ✓

    Hi @Paul Higgins 

    Hope you are fine, please try the following formula:

    =COUNTIFS({Reports Names}, HAS(@cell, Name@row), {Reports Week}, @cell <> "result")

    PMP Certified

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!