How do implement SumIfs with criteria in a NamedRange
Posted on 2016-09-05
I am attempting to sum a range, but only if meets criteria based within a named range. Is this possible....In my case I have a named range called produce. If I find the produce value in the NamedRange, (but only if the value is found in the Named Range from $A$10:$A$15) do I want to sum values.
Thus for criteria1 I have $A$10:$A$15, but it does not work...
Thus for criteria2 I have $A$15:$A$20, but it does not work...