+ Reply to Thread
Results 1 to 4 of 4

SUMIF for multiple rows

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    Madison, WI
    MS-Off Ver
    2007
    Posts
    1

    Cool SUMIF for multiple rows

    Hi all,


    I want to sum multiple cells in a column if the title is a certain value.

    A B C D E
    1 2008 2009 2010 2011 2012
    2 23 45 65 32 11
    3 10 10 10 24 22
    4 32 43 24 76 43
    5 82 13 57 99 34
    6 12 43 21 88 56

    I wanted a value for row 2, year 2008 through 2012 separately
    I also wanted a value for row 3 for each year.

    The problem arises when I want row 4-6 summed for each year.

    I am linking to another tab which specifies the year. on the left and the category (rows) on the top.

    Thanks in advance!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,905

    Re: SUMIF for multiple rows

    Hi, welcome to the forum

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF for multiple rows

    Not real clear.

    Suggest you post a SMALL sample file and show us what results you expect.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577

    Re: SUMIF for multiple rows

    Okay, for table two, in the first row I put the min row you want summed (i.e. 2 or 4) and in row 2 I put the maximum row you want summed (i.e. 2 or 6)
    Then the formula in H3 that can be copied across and down is

    =SUM(INDEX($A$2:$E$6,MATCH(H$1,{2,3,4,5,6},0),MATCH($G3,$A$1:$E$1,0)):INDEX($A$2:$E$6, MATCH(H$2,{2,3,4,5,6},0),MATCH($G3,$A$1:$E$1,0)))
    See attached.
    Attached Files Attached Files
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] SUMIF for multiple rows
    By JustMark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2014, 09:30 PM
  2. [SOLVED] Using SUMIF across multiple rows
    By wvpersephone13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2012, 01:12 PM
  3. Sumif on multiple matching rows
    By w1nta in forum Excel General
    Replies: 2
    Last Post: 05-07-2012, 09:35 PM
  4. Specify multiple rows for SUMIF range?
    By necht_angel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2011, 04:15 AM
  5. Sum multiple rows (SUMIF?)
    By nougain in forum Excel General
    Replies: 3
    Last Post: 03-10-2007, 11:29 AM

Tags for this Thread

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