SUMIF and Exclude certain criteria

[L40]

I have a formula that’s not summing correctly and I’m not sure where I went wrong. I have multiple data where I’m trying to exclude certain names i.e. Sam, Jill, Don and Robert. In other words I want to sum all completed task for all other names in column “B” excluding the names mentioned. Column “AB”contains numbers of completed task. Column “Y” is the date the transaction took place and “F57” is the field I want the reference to sum transactions for that specific date. <o></o>
=SUM(SUMIFS('Data Dump'!AB:AB,'DataDump'!B:B,{"<>Sam","<>Jill","<>Don","<>Robert"},'DataDump'!AD:AD,{"ZIP"},'Data Dump'!Y:Y,"="&F57))<o></o>
<o></o>Any help would be greatly appreciated.<o></o>
<o></o>Thanks,<o></o>

 

[Aladin Akyurek]

Try...

=SUM(SUMIFS('Data Dump'!AB:AB,'DataDump'!B:B,{"?*","Sam","Jill","Don","Robert"},'DataDump'!AD:AD,"ZIP",'Data Dump'!Y:Y,"="&F57)*{1,-1,-1,-1,-1})

 

[Dave Patton]

maybe
=SUMIFS(AB:AB,B:B,"<>Sam",B:B,"<>Jill",B:B,"<>Don",B:B,"<>Robert",AD:AD,"ZIP",Y:Y,F57)

 

[L40]

It returns the same answer that I previously had with the formula I provided.

 

[Aladin Akyurek]

It returns the same answer that I previously had with the formula I provided.

Did you try post #2 ?

 

[L40]

Yes, it also returned the same answer from my original formula.

 

[L40]

I was sitting here wondering how can 3 people get the same answer and it still be wrong. **** Now I feel so dumb **** After looking at the results all three formulas are correct. Turns out when I was filtering the data I was not excluding those names but instead all other names were not included. Its been a long day. I appreciate all the help.

Thank you

 

[Aladin Akyurek]

Yes, it also returned the same answer from my original formula.

So, is that wrong?

What do you expect from excluding x and y from the data below?

x	5
y	5
a	10
b	20
c	30
x	20

<tbody>
</tbody>

 

[L40]

No its all correct. I was filtering excel incorrectly. All the formulas that were posted all worked and gave the correct answer. It was my error. Thank you all for your assistance.