ARRAY IN SUMIFS WITH "<>" CRITERIA
Posted on 2014-04-29
I have a SUMIFS formula where I would to like to have one of the criteria be an array of values that a particular range cannot be equal to. I undertsnad how to do this when I only want to include an array of values, but I am having trouble doing the opposite.
**Please note the values in the array are text, not numbers.
I can make it work with a SUMPRODUCT formula, but I wanted to see if this was possible as well.
Thanks for any help!