Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Sum Range Using 1 Column of Named Range as Criteria

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

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

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

  • #2
    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, 14:48.
    Kris

    ExcelFox

    Comment


    • #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, 14:51.

      Comment


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

        Thanks Kris.

        That's exactly what I was looking for.

        Brad.
        Brad.

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X