+ Reply to Thread
Results 1 to 4 of 4

SumIf two columns meet criteria

  1. #1
    Forum Contributor
    Join Date
    02-20-2009
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    467

    SumIf two columns meet criteria

    On the attached example i would like a formula in F2 which sums all the values where column equals "Smith" and column B equals "Golf European".

    I'm assuming it would involve the SumIf formula but i'm not sure if this is the best solution when the criteria is in two columns?

    Thanks,
    Adam.
    Attached Files Attached Files
    Last edited by adam2308; 11-25-2009 at 02:30 PM.

  2. #2
    Valued Forum Contributor jj72uk's Avatar
    Join Date
    03-22-2008
    Location
    Essex, England
    MS-Off Ver
    Work - Office 2000, Home - Office 2007E
    Posts
    360

    Re: SumIf two columns meet criteria

    Maybe something like

    =SUMPRODUCT((A2:A17="Smith")*(B2:B17="Golf European")*(C2:C17))

  3. #3
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: SumIf two columns meet criteria

    Hi Adam,

    Attached is a sample file for you ...

    HTH
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: SumIf two columns meet criteria

    I like SumProduct as well, here is another way, if you had the name in D1 and the Sport in E1, your Sumproduct formula would be

    =SUMPRODUCT((A2:A17=D1)*(B2:B17=E1)*(C2:C17))

+ 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