<div>
Can you try explaining that again? A sample workbook is great for making things clearer.
</div>


Can you try explaining that again? A sample workbook is great for making things clearer.

<div>
Did not realize I have to single out each criteria...thx
</div>


Did not realize I have to single out each criteria...thx

<div>
<div class="content wysiwyg-content">
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. &nbsp;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.<br />
<br />
Range1<br />
Thus for criteria1 I have $A$10:$A$15, but it does not work...<br />
<br />
Range2<br />
Thus for criteria2 I have $A$15:$A$20, but it does not work...
</div>
</div>


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...

How do implement SumIfs with criteria in a NamedRange

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.