• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 110
  • Last Modified:

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.

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...
1 Solution
Wayne Taylor (webtubbs)Commented:
Can you try explaining that again? A sample workbook is great for making things clearer.
Rob HensonFinance AnalystCommented:
From your question it looks like you are using a range of cells for the criteria value.

Syntax for SUMIFS:


SumRange - Range to be summed
CriteriaRange 1 - Range containing Criteria1 values
Criteria1 - single cell reference containing single criteria1 value
CriteriaRange 2 - Range containing Criteria2 values
Criteria2 - single cell reference containing single criteria2 value

In addition, the Ranges have to be the same size but not necessarily lined up, for example your 10:15 and 15:20 should work as they are both 6 rows but don't line up.

Hope that helps.
upobDaPlayaAuthor Commented:
Did not realize I have to single out each criteria...thx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now