Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Sum for multiple Conditions; EXCEL 2003

    I used this formula to return the number of times that "Monika" appeared for a given date range.

    =SUMPRODUCT((DateReceived>=$A4)*(DateReceived<=$B4 )*(Validationor="Monika"))
    A4 contains my minimum date and B4 contains my upper date range.

    Now, I want to ADD (sum) the numbers in range AN3:AN5000 for the above criteria.
    FYI, the name of range AN3:AN5000 is NumReports


    -Jody

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Hi Jody - If possible, please attach a sample spreadsheet.

    Thanks

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Sum for multiple Conditions; EXCEL 2003

    Attached is my spreadsheet.

    Solution to be on Metrics tab, cel L4
    Solution should be: 119 (The sum of 33 cells)
    Criteria = (DateReceived>=$A4)*(DateReceived<=$B4 )*(Validationor="April Whitfield") -->yes, I changed the name from above, I wasn't planning on posting the spreadsheet and thought it easier if the name used in the example wasn't the name of a month

    Add named range "NumReports" (Ad Hoc Reports tab, AN3:AN5000)

    BTW: I know that I am attaching a 2007 file, but it WILL be in a 2003 spreadsheet. I am posting from home where I have 2007

    -Jody
    Attached Files Attached Files

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    =SUMPRODUCT((DateReceived>=$A4)*(DateReceived<=$B4 )*(Validationor="April Whitfield")*NumReports)

    Steve

  5. The Following User Says Thank You to sdckapr For This Useful Post:

    musical1 (2011-05-03)

  6. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Edison, New Jersey, USA
    Posts
    215
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Thank you! I had danced around so many similar attempts, but I was trying to make it more difficult than it was.

    Merci,
    Jody

Posting Permissions

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