Calculating totals on rows, summarizing in separate columns.

[EddieD]

Hello everyone.
I'm not entirely sure how to explain this one properly, here's my attempt.

1. I have a spreadsheet with 200 rows, each is a different SKU, with a different cost associated with it.
2. Then I have a series of months where we would need to plan the quantities of our SKU purchasing.
3. The same SKU might be purchased in multiple months in that same year
4. I want to add up all of the purchases for one month, and display value in once cell, showing me the impact of these costs of all the SKUs for that particular month.

How would you approach this?

Thank you in advance for your help.

 

[ZMyrrh]

If you were to do this with one row what would the formula look like. Sorry, I'm just confused as what the objective is. Like this isn't just a sum function right?

 

[EddieD]

Thank you. I have drawn another diagram, and copied the formula I am currently using to get the result of one row. I could get the number I want by adding this formula to each of the 200 rows to add the total purchases for 'January' in column CG - but im sure there's a better way.

=SUM($BS11*BU11)+SUM($BS12*BU12)

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=SUMPRODUCT(BS11:BS200,BU11:BU200)

 

[EddieD]

Thank you very much for your help. This is exactly what I needed.
I will update the account details.

 

[Fluff]

Glad we could help & thanks for the feedback.