Totalling subsets of data within one workbook

[Elapses]

Hi Guys,

First time poster here. Relatively new to complex Excel formulas, but excited to learn!

I couldn't seem to find any similar threads (though it may be because I am lacking the appropriate description?).

So, I have a spreadsheet containing our company's current clients and their monthly spend per unit. It is all on one spreadsheet and I want to calculate the total unit cost per month per company.

I have the columns: Company, Unit Description, Unit $ Amount.

There is a row for every individual unit each company owns. I wish to extract the total unit $ amount per customer.

Any advice appreciated. I am a n00b so simple explanations appreciated, but I'm a quick learner.

Thanks in Advance!

[vlady]

Welcome to the forum.
May i suggest that you upload a sample file for the members to work with .


To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Regards,
Vladimir