I want to exclude multiple strings off the sum. So I put them inside the brackets. Hoping they'll sum everything without these strings. But unluckily, not working.

I want B14 to result 80 - exclude A2 and A7. So I put =SUMIFS(A2:A7,{"<>"&A2,"<>"&A7},E2:E7), but no luck.

I put the sample here :

CodePudding user response：

Try this:

=SUMIFS(E2:E7, A2:A7, "<>Transport", A2:A7, "<>Cutlery")

Or:

=SUMIFS(E2:E7, A2:A7, "<>"&A2, A2:A7, "<>"&A7)

Result: