Summing the value of a range of cells

[Teblol]

Hi All,

I have the below code that combines the text in column C if the data in columns A, B, and D match. Is there any way to have the values in columns E totaled as well? If so, I would also like the values in column F added as well. The results I would like are on sheet 1 of my attachment. The raw data is on sheet 2.

Please Login or Register  to view this content.

[AB33]

See if this works for you.

[TMS]

Please Login or Register  to view this content.

[TMS]

@AB33: Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!

[AB33]

Hi Trevor,
There has numerous discussions on this topic..I know you are not going to like it, but I always post a sample book with code attached to it if the poster has posted an excel book.
I am on the minority on this approach.No ifs and buts.

[TMS]

@AB33: I don't think there's an issue posting a sample workbook. The suggestion is that you post the code in the body of the reply so others don't necessarily need to download and open the workbook. But, as you wish

[Teblol]

Clash of the Guru's. Thank you both. I love how I spend hours trying to find a solution and both of you come up with it on your own in less than 20 minutes.

[TMS]

No clash Maybe a slight difference of opinion You posted code AND a workbook; I returned just code, AB33 returned just a workbook. My guess is that you don't need the workbook back but it's often good to see the code updated and working IN the workbook.

And thanks for the rep

[Teblol]

How could I make it so that this macro cycles through six different sheets? The sheet names are Div.1, Div. 6, Div. 9, Div. 11, Div.12, and Div. 13.

[AB33]

You should have started a new thread. There are few ways, one way

Please Login or Register  to view this content.

[Teblol]

Sorry I thought since it was working with the same code it would be OK to just reopen. Next time I will start a new thread. I do not need to name all of the sheets?

[AB33]

No, the code loops through sheets which have a "Div" as sheet name and ignore the rest of sheets

[Teblol]

How would I change the original code to work on a different workbook that has matching data in the "Account #" column (1), "Item" column (4), and "Request" column (6), and the values I want to sum in my "Order Qty." column (5)? There are a total of 8 columns.

Please Login or Register  to view this content.

I updated the names but I do not know how to successfully update the rest. My hour of trying has gotten me no where.

[AB33]

Please attach a sample book with a desired result for testing.

[Teblol]

Results can be found on the second sheet. Thanks!

[AB33]

Your description of the columns do not match with the data you attached.

Please Login or Register  to view this content.

[Teblol]

Sorry about that. I had changed something after my original description and didn't realize it would mess with the results.

Thank you so much! I see how the macro works now. I can add cases without actually using them. I am still not entirely sure how the summing works but I am sure I will figure it out. Thanks again.

[Teblol]

Hey AB33,

I am having an issue getting the code that runs through all of the sheets to work. I have created a new thread: http://www.excelforum.com/showthread...20#post4427320