Sumifs that does not equal a range of values

Hi All

I was hoping if (excuse the pun :p ) someone could please help with a sumifs formula.

=SUMIFS('DATA'!D:D,'DATA'!O:O,"<>"&{1,3,6,12,24},'DATA'!P:P,$A$2,'DATA'!D:D,"<="&$D$2,'DATA'!D:D,">"&$C$2)

Its just the <>"&{1,3,6,12,24} part, i think everything else works fine.

I have other formula's that pick up the required figures that match 1 in Column O on the data sheet, along with 3 6 12 and so on.

What I am trying to do is pick up the "left overs" were someone has entered the wrong number in the data sheet in Column O (should only be 1,3,6,12,24)

So I thought i could say, that if the value does not equal anything in the {} brackets, I want to add up those.

So for example, if someone has entered a 2 or 7 or 25 in DATA Column 0, then I want to add up the values in Data Column D (subject to the other criteria)

Any help would be greatly appreciated

Thank you

Thank you so much guys for responding so quickly.

Special-K, yes could have done it the "cheats way", however would prefer not to do that in case the original formulas contain errors etc.

Tony, thank you so much, that worked perfectly

I wouldn't call Special-K's suggestion a 'Cheats way'
It's perfectly logical.
And actually more efficient, because you've ALREADY done the work of testing column O for the values of 1 3 6 12 and 24.
No need to Do that again..

If you ALREADY have the SUM of 1 3 6 12 and 24
Logically, the TOTAL sum of ALL vlaues Minus the sum already achieved = desired sum of NOT 1 3 6 12 24

Although you'd have to include all the other criteria as well in the overall sum.

So I assume then this is your formula that sums the ones that ARE = 1 3 6 12 and 24
=SUMIFS('DATA'!D:D,'DATA'!O:O,{1,3,6,12,24},'DATA'!P:P,$A$2,'DATA'!D:D,"<="&$D$2,'DATA'!D:D,">"&$C$2)
Say that formula is in D2 for example

Then to get sum of the ones that DO NOT = 1 3 6 12 and 24,

=SUMIFS('DATA'!D:D,'DATA'!P:P,$A$2,'DATA'!D:D,"<="&$D$2,'DATA'!D:D,">"&$C$2)-D2