SUMIFS with NOT CONTAINS as well as no blanks

I'm trying to create a formula that sums the duration only if there is something in the Assigned to column. I keep getting #INVALID OPERATION. What am I missing? Thanks in advance!

=SUMIFS(Duration:Duration, [Assigned To]:[Assigned To], NOT(CONTAINS("Client", @cell)), <>"")

Best Answer

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Answer ✓

    Christy's formula will give you what you asked for in your original question. Now if you want to sum only if the assigned to contains "Client", then just change the criteria to the one you have in contains,

    =SUMIF(Duration:Duration, [Assigned To]:[Assigned To], CONTAINS("Client", @cell))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!