SUMIFS, exclude range of criteria

Hi XL Maestros,

Here I have a SUMIFS where I would like to exclude a dynamic range of values in a column (number of values are changing constantly). I cannot find a similar solution on web, I wonder if anybody has got a workaround or something? The syntax I'm after is something like this:

=SUMIFS($B$2:$B$100,$C$2:$C$100,$C$1,$D$2:$D$100,"<>$E$2:$E$20")

Any help will be much appreciated!

Edited - I suppose the solution, if there will be one, will apply to COUNTIFS too?

Thanks