+ Reply to Thread
Results 1 to 2 of 2

sum the values of a range based upon multiple ranges and criteria

  1. #1
    LiveIt...
    Guest

    sum the values of a range based upon multiple ranges and criteria

    Help!

    Range("A2:A57") may contain values from "A-K"
    Range("B2:B57") may contain values M, T, W, R, F for the days of the week.
    Based on those ranges I need to sum Range("D2:D57") where both criterias are
    met.
    example:
    Where Column A = "A" and where column B = "M", sum every cell ("D2:D57")
    that meets both criteria, where column A may have 15 cells that contain "A"
    and column B may have 5 cells that contain "M" leaving a maximum of 5 cells
    that can be summed.

    Thanks


  2. #2
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    LiveIt,

    =SUMPRODUCT((A2:A57="A")*(B2:B57="M")*(D2:D57))

    HTH

    Steve

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1