SUMIFS with NOT CONTAINS as well as no blanks

Christy Kooiman

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

Sameer Karkhanis

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

Leibel S

@Christy Kooiman

Is the below what you are looking for?

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

Christy Kooiman

Unfortunately no...it's adding up all lines now instead of just those containing "Client"?

Sameer Karkhanis

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