Sum transactions for the month for each company

[GraceTilly]

Each month I trade with various companies and I have a spreadsheet with the data on it, month by month. In column B I have the names of different companies I do business with, in the corresponding cell in column G I have the value that I spend with each company per transaction. What I am trying to do is in column K, I have a list of all the companies and I want to somehow in column L put in a formula in the cell by the company name that will select the company from column B and all the transaction values of that company for the month and put them in the corresponding cell in column L.
I thought the use of the INDEX function might help but then there would simply be too many variants I:E company names that consistently change month on month. Please could anyone assist me with this.

 

[6StringJazzer]

Do you mean that each Excel worksheet has a different month?

I was going to tell you that the easiest way to do this is with a pivot table but this really threw me:

there would simply be too many variants I:E company names that consistently change month on month

If a single company's name changes during the month, how do you associate them all as the same company? This is not an Excel question--you would face the same problem doing it manually.

Here is the concept without the complication of company names changing.

 

[6StringJazzer]

P.S. It's always better to use the title to describe what you want to do, not speculate as to what the solution might be. I can think of a couple of ways to solve this but INDEX is not one of them. Maybe "Sum transactions for the month for each company"

 

[GraceTilly]

Do you mean that each Excel worksheet has a different month?

I was going to tell you that the easiest way to do this is with a pivot table but this really threw me:

If a single company's name changes during the month, how do you associate them all as the same company? This is not an Excel question--you would face the same problem doing it manually.

Here is the concept without the complication of company names changing.

View attachment 120805

Many thanks for the response, it is a miscommunication on my behalf, what you have indicated with the pivot tables is correct. The companies don't change names there are multiple transactions by multiple companies and the use of a pivot table is the best solution.
Many thanks for your time and patience and your comment in your other thread has been noted.

 

[6StringJazzer]

Glad to help. If you have any trouble implementing this in your actual file let me know. I can provide a link to my sample file.

 

[smozgur]

Many thanks for the response, it is a miscommunication on my behalf, what you have indicated with the pivot tables is correct.

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

P.S. It's always better to use the title to describe what you want to do, not speculate as to what the solution might be. I can think of a couple of ways to solve this but INDEX is not one of them. Maybe "Sum transactions for the month for each company"

@6StringJazzer - Thanks for the title suggestion. I have changed it as you recommended to also help future readers.