SUMIFS Function with an OR Statement In One Criteria

[nevi]

Hey Everyone!!

I have a bit of a tricky one and I am at an absolute loss as to how do do this.

I need to do a SUMIFS with 2 sets of Criteria, but I need the second Criteria to be an OR Statement. The numbers I am adding up is in Column E, with any where from about 20,000 to about 60,000 records (will fluctuate all the time). The first Criteria is easy - match up the name in AG12 with any of the names in Column C. The second criteria is to match up the numbers in Column A with any of the numbers in AD1 through AD40.

I tried this but it didn't work: =SUMIFS(E:E,C:C,AG12,A:A,AD1:AD40). I've alos tried a million other variations of that, imbedded SUM(IF( statements, SUMPRODUCT statements, and DSUM statements and no luck. I can't find anything that allows me to make that second second criteria look at the numbers in Column AD as being AD1 or AD2 or AD3 so on and so forth.

Any help would be greatly appreciated. Thanx a million!!!

[BadlySpelledBuoy]

Have a look at the attached and see if this helps at all...

The formula in the yellow cell looks at ColA to check for those that match the list in ColG. It then checks for an "X" in ColC and sums ColB.

Sounds like what you're trying to do and should be clear enough to easily adapt to your data.
If not, post a sample and we'll go from there.

[nevi]

Worked like a charm! Thank you soooo much!! :D

[BadlySpelledBuoy]

Happy to help