Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2004
    Posts
    37

    Unanswered: Conditional sum with AND

    Hi,

    Does anyone know if you can do a conditional sum with an AND in the criteria.

    Such that I get a sum if

    ColumnA = This
    AND
    ColumnB = That

    Or is there another method for doing this sum

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    It's likley you can use the SumProduct function, but would need a little more info to produce an example.

    MTB

  3. #3
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72
    Hi

    Indeed SUMPRODUCT is like SUMIF on steroids.

    In Excel 2007 Microsoft has created 3 new functions SUMIFS, COUNTIFS and AVERAGEIFS that can do a lot of what SUMPRODUCT can do but not everything.

    During a recent visit to their campus in Redmond I showed them what I do with SUMPRODUCT and they were flabergasted. Useless to say that the creators of the new functionsdidn't become my friends.

    SUMPRODUCT is at the center of my practiceas consultant and mentor. SUMPRODUCT empowers regular users and reduces substantially the programming needs.

    If 5% of Excel users knew about SUMPRODUCT it would change the world of reporting and a lot of small businesses would not need to buy expensive, complex and limited reporting programs.

    See an introduction on my website.
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  4. #4
    Join Date
    Dec 2004
    Posts
    37

    Got it working

    Thanks for the replies.

    Got it working with DSUM (with some column labels), however it looks as though SUMPRODUCT would also have worked. I will bear SUMPRODUCT in mind for the future.

    Many thanks
    Mike

  5. #5
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72
    Micheal

    See my new thread and download my file. It will change your life (as data analyst).
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

Posting Permissions

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