+ Reply to Thread
Results 1 to 5 of 5

How do I sum with two critera?

  1. #1
    Clare
    Guest

    How do I sum with two critera?

    How do I create a formula to SUM but SUM IF against two seperate criteria.

  2. #2
    Biff
    Guest

    Re: How do I sum with two critera?

    Hi!

    Need details! Be specific!

    Details, people! Details! <g>

    Biff

    "Clare" <[email protected]> wrote in message
    news:[email protected]...
    > How do I create a formula to SUM but SUM IF against two seperate criteria.




  3. #3
    Rowan
    Guest

    RE: How do I sum with two critera?

    One way is to use the sumproduct formula:

    http://www.xldynamic.com/source/xld....T.html#explain


    "Clare" wrote:

    > How do I create a formula to SUM but SUM IF against two seperate criteria.


  4. #4
    keen learner
    Guest

    Re: How do I sum with two critera?

    Hi, this is also one answer that I am waiting for with baited breath, because
    I am fond of the sumif function, which only has one criteria, somehow there
    must be a way to adapt this function to accept two criteria, come on guys

    "Biff" wrote:

    > Hi!
    >
    > Need details! Be specific!
    >
    > Details, people! Details! <g>
    >
    > Biff
    >
    > "Clare" <[email protected]> wrote in message
    > news:[email protected]...
    > > How do I create a formula to SUM but SUM IF against two seperate criteria.

    >
    >
    >


  5. #5
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon guys

    OK, this is how it's done


    A B C
    Product 1 Manchester 10
    Product 1 London 15
    Product 2 Manchester 12
    Product 1 London 20
    Product 1 London 25
    Product 2 London 11
    Product 1 Manchester 8
    Product 2 Manchester 6
    Product 1 Manchester 5
    Product 1 Manchester 4

    This formula will add up all the occasions where column A=product 1 and column B = Manchester.

    =SUM(IF($A$2:$A$11="Product 1",IF$B$2:$B$11="Manchester",$C$2:$C$11,0),0))

    Just remember it's an array formula so to commit it use ctrl + alt + enter.

    HTH

    DominicB

+ 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