Results 1 to 5 of 5

Multi Condition Aggregation

Threaded View

  1. #1
    Registered User
    Join Date
    01-05-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Multi Condition Aggregation

    I am trying to get a formula that will return a value based on two criteria from a different sheet.
    I have tried array's, I have tried if/and, I am at a loss. Any help would be greatly appreciated.

    Column1 Column2 Column3
    MOM ---- 1 ---- 10
    MOM ---- 2 ---- 15
    DAD ---- 3 ---- 20
    SON ---- 2 ---- 25
    DGHT ---- 5 ---- 30
    SON ---- 9 ---- 35
    DAD ---- 3 ---- 40

    All of this info is pasted on a sheet labeled "1"
    on my other sheet (same workbook)
    I would like to sum everything in column3 that is labeled DAD in column1 that is also >2 in column2
    So in this case it would give me 60

    Let me know if this is not clear. Thanks in advance for any help
    Last edited by DonkeyOte; 01-05-2011 at 10:39 AM.

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