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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!