+ Reply to Thread
Results 1 to 9 of 9

SUMIFS with sum value in multiple columns

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    5

    SUMIFS with sum value in multiple columns

    I read a previous posted thread for this issue, but it returned a value of #N/A. Here's my dilemma:

    I have a delineator in Column C. I need it to select my "delineator" in Column C and then sum total the values on the same line from columns U:AF. This table area begins at row 8 through row 435. Essentially, the delineator is a project section and the sum values are the expenditures per month for 12 months. (Hopefully, that doesn't make it more confusing...) Currently, all of my data is on one page. (Even better would be if I could use delineators from 2 columns...)

    A similar formula is working well for me, but is only for one column each:
    =SUM(SUMIFS(T8:T435,$D$8:$D$435,{"Open","Complete"}))

    Thanks for your help!
    XLFriend
    Last edited by XLFriend; 12-04-2018 at 04:22 PM.

  2. #2
    Valued Forum Contributor dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Agawam, MA
    MS-Off Ver
    Microsoft Office 365
    Posts
    843

    Re: SUMIFS with sum value in multiple columns

    it would be very helpful if you could include a sample worksheet for us.

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,013

    Re: SUMIFS with sum value in multiple columns

    Hello XLFriend. Welcome to the forum.

    Sounds like an intriguing problem.

    Have you tried MMULT? It will return multiple sums of multiple columns or rows in an array.

    In the meantime I have to agree with dosydos. We need something more concrete to work with in context.

    If you are not familiar with how to upload to this site please follow these instructions:

    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

    be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”
    The file name will appear at the bottom of your reply.
    Dave

  4. #4
    Registered User
    Join Date
    12-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    5

    Re: SUMIFS with sum value in multiple columns

    Ok, I've added an example - this is a much larger file than what I've submitted. Note there are 2 pages to the workbook. I haven't used the MMULT function before - I'll give that a try as well.

    Thanks for your help!
    XL Friend
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    5

    Re: SUMIFS with sum value in multiple columns

    I tried the MMULT function. Doesn't seem that will work because I need the SUMIF function part of the equation...unless it can be buried inside the equation...

  6. #6
    Registered User
    Join Date
    12-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    5

    Re: SUMIFS with sum value in multiple columns

    Oh - I apologize for the multiple posts here. I forgot to tell you where this formula would live. The cell area is T46-54.

  7. #7
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,832

    Re: SUMIFS with sum value in multiple columns

    Please try Sumproduct

    T46
    =SUMPRODUCT(($C$8:$C$31="61010 North Pacific Aquarium")*$U$8:$AD$31)

    T47
    =SUMPRODUCT(('Other Funds CashFlow'!$C$8:$C$30="Zoo Operations Pacific Seas Aquarium")*'Other Funds CashFlow'!$JD$8:$JM$30)

  8. #8
    Registered User
    Join Date
    12-04-2018
    Location
    Washington, USA
    MS-Off Ver
    2013
    Posts
    5

    Re: SUMIFS with sum value in multiple columns

    Can you hear me shouting over here?

    THANK YOU, THANK YOU, THANK YOU! I love it when a formula works! Oh man!

    Thank you so much, Bo_Ry!

  9. #9
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,832

    Re: SUMIFS with sum value in multiple columns

    Happy to help. Thank you for Rep.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. SUMIFS on multiple columns and multiple criteria
    By j9mcl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-05-2018, 08:32 AM
  2. SUMIFS Multiple Columns
    By nathanexcelhelp in forum Excel General
    Replies: 6
    Last Post: 09-22-2016, 06:46 AM
  3. Sumifs with or statement over multiple columns
    By sjennings007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-07-2015, 11:05 PM
  4. [SOLVED] SUMIFS/AVERAGEIFS across multiple columns
    By keith740 in forum Excel General
    Replies: 30
    Last Post: 06-25-2015, 01:25 PM
  5. SUMIFs across multiple columns (SUMPRODUCT?)
    By source in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 01-26-2015, 02:39 PM
  6. Can I use sumifs on a range with multiple columns?
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2014, 03:11 AM
  7. SUMIFS with multiple sum range columns
    By bvmk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2013, 03:39 PM

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