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:
Any help will be much appreciated!![]()
=SUMIFS($B$2:$B$100,$C$2:$C$100,$C$1,$D$2:$D$100,"<>$E$2:$E$20")
Edited - I suppose the solution, if there will be one, will apply to COUNTIFS too?
Thanks
Bookmarks