Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Sum Range Using 1 Column of Named Range as Criteria

1. ## Sum Range Using 1 Column of Named Range as Criteria

Does anyone know how to use SUM Formula a column from within a Named Ranges or Dynamic Named Range?

For example, if the range name "MyData" refers to the address: A1:G10, how could I sum all the numbers in column G of that range where column A meets certain criteria.

Eg., Column A holds fruit names:
Apple
Orange
Banana
Apple

and column G holds quantities of the particular fruit.

I'd like to sum column G (quantity) for only those quantities that match "Apple" in column A.

Last edited by Dave Hawley; December 21st, 2006 at 14:47.

Excel Video Tutorials / Excel Dashboards Reports

2. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,648

## Re: Sum A Column Within A Dynamic Named Range

Hi,

=SUMIF(INDEX(MyData,,1),"Apple",INDEX(MyData,,7))

Multiple Criteria SUM

HTH
Last edited by Dave Hawley; December 21st, 2006 at 14:48.

3. ## Re: Sum A Column Within A Dynamic Named Range

Why not simply

=SUMIF(Fruits,"Apple",Numbers)

Where Fruits is a Named Ranges of G1:G10 and Numbers is another of A1:A10
Last edited by Dave Hawley; December 21st, 2006 at 14:51.

4. ## Re: Sum A Column Within A Dynamic Named Range

Thanks Kris.

That's exactly what I was looking for.

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno