SUMIFS with sum value in multiple columns

[XLFriend]

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

[dosydos]

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

[FlameRetired]

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.

[XLFriend]

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

[XLFriend]

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...

[XLFriend]

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

[Bo_Ry]

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)

[XLFriend]

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!

[Bo_Ry]

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.