asked on
How do implement SumIfs with criteria in a NamedRange
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.
Range1
Thus for criteria1 I have $A$10:$A$15, but it does not work...
Range2
Thus for criteria2 I have $A$15:$A$20, but it does not work...
Range1
Thus for criteria1 I have $A$10:$A$15, but it does not work...
Range2
Thus for criteria2 I have $A$15:$A$20, but it does not work...
Microsoft Excel
Last Comment
upobDaPlaya
Can you try explaining that again? A sample workbook is great for making things clearer.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Did not realize I have to single out each criteria...thx