Results 1 to 9 of 9

SUM Range more than one column - SUMIF

This is a discussion on SUM Range more than one column - SUMIF within the Excel Questions forums, part of the Question Forums category; Hi, How would I SUM all the results from results 1-5 if say ITEM in column A = C? SUMIF ...

  1. #1
    Board Regular shemayisroel's Avatar
    Join Date
    Sep 2008
    Location
    Sydney - Australia
    Posts
    1,867

    Default SUM Range more than one column - SUMIF

    Hi,

    How would I SUM all the results from results 1-5 if say ITEM in column A = C?

    SUMIF wont work as it only sums the first column...

    ABCDEF
    1ITEMRESULT 1RESULT 2RESULT 3RESULT 4RESULT 5
    2A122772
    3B107555
    4C21772
    5A1010 337
    6A5 2335
    7B133 7
    8C7 1 2
    9C555
    10B72772
    enercheenhologoskaihoogosenprostontheonkaitheosenhologosnarchhnoogovkailogohnprvtonqeonkaiqeovhnologov

  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    14,601

    Default Re: SUM Range more than one column - SUMIF

    Try...

    =SUM(IF(A2:A10="C",B2:F10))

    ...confirmed with CONTROL+SHIFT+ENTER.
    Domenic Tamburino
    Microsoft MVP - Excel
    xl-central.com - "For Your Microsoft Excel Solutions"

  3. #3
    MrExcel MVP sanrv1f's Avatar
    Join Date
    Jan 2009
    Location
    Chennai, India
    Posts
    3,319

    Default Re: SUM Range more than one column - SUMIF

    try

    =SUMPRODUCT((A2:A10="A")*B2:F10)

    or

    =SUM(IF(A2:A10="A",B2:F10))

    with CSE
    regards
    Sankar
    show your sheet on the board, get HTML maker


    யாதும் ஊரே, யாவரும் கேளிர்; தீதும் நன்றும் பிறர்தர வாரா

  4. #4
    Board Regular T. Valko's Avatar
    Join Date
    May 2009
    Location
    Pittsburgh
    Posts
    16,133

    Default Re: SUM Range more than one column - SUMIF

    Try this:

    =SUMPRODUCT((A2:A10="A")*B2:F10)
    .
    Biff
    Microsoft MVP - Excel

    Using Excel 2002, 2007
    KISS - Keep It Simple Stupid

  5. #5
    Board Regular shemayisroel's Avatar
    Join Date
    Sep 2008
    Location
    Sydney - Australia
    Posts
    1,867

    Default Re: SUM Range more than one column - SUMIF

    Quote Originally Posted by Domenic View Post
    Try...

    =SUM(IF(A2:A10="C",B2:F10))

    ...confirmed with CONTROL+SHIFT+ENTER.
    Of course - thank you.

    Excuse my brain freeze. I guess I was trying to tackle it with a sledge hammer when a simple tap with a hammer did the trick.

    Thanks

    And BTW, your website is GREAT. Really handy and easy to uderstand solutions. Well done.
    enercheenhologoskaihoogosenprostontheonkaitheosenhologosnarchhnoogovkailogohnprvtonqeonkaiqeovhnologov

  6. #6
    Board Regular shemayisroel's Avatar
    Join Date
    Sep 2008
    Location
    Sydney - Australia
    Posts
    1,867

    Default Re: SUM Range more than one column - SUMIF

    Thanks sanrv1f & #NAME?

    My bad habit with SUMPRODUCT of using , at the end rather than *

    Thanks for the reminder and solution
    enercheenhologoskaihoogosenprostontheonkaitheosenhologosnarchhnoogovkailogohnprvtonqeonkaiqeovhnologov

  7. #7
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    14,601

    Default Re: SUM Range more than one column - SUMIF

    Quote Originally Posted by shemayisroel View Post
    Of course - thank you.
    You're very welcome!

    And BTW, your website is GREAT. Really handy and easy to uderstand solutions. Well done.
    Thank you, shemayisroel! I really appreciate it!
    Domenic Tamburino
    Microsoft MVP - Excel
    xl-central.com - "For Your Microsoft Excel Solutions"

  8. #8
    New Member
    Join Date
    Apr 2012
    Posts
    3

    Default Re: SUM Range more than one column - SUMIF

    Does anyone know how to sum multiple coloumns with multiple conditions? Should I use sumif or sumproduct function?

  9. #9
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    14,601

    Default Re: SUM Range more than one column - SUMIF

    Quote Originally Posted by Acon View Post
    Does anyone know how to sum multiple coloumns with multiple conditions? Should I use sumif or sumproduct function?
    It really depends on your actual requirements. I'm on my way out, so I would suggest that you start a new thread and provide an example of the data, describe what you'd like to do, and provide the actual results based on your sample data.
    Domenic Tamburino
    Microsoft MVP - Excel
    xl-central.com - "For Your Microsoft Excel Solutions"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com