$ Total column formula with slight twist

[excelquestion123]

HI,

I would like a formula to work out the $ spend of clients who are listed in columns. Each row represents a new product. Each column only has the number of units of that item sold to that client. The $ sell price of that item is in a master column which is the same sell price for all clients. The formula would need to work out the total $ turnover for all items sold to that client based on the price of the item in the master $sale price column.

column a column b column c column d column e
Row 1 sell price client a client b client c
Row 2 Product 1 $10 4 5
Row 3 product 2 $25 5 10 15
Row 4 Product 3 $40 5
Row 5 Product 4 $15 10 6
Row 6 This row requires the formula $315 $?? $??

Hope this makes sense.

Your help would be much appreciated.

Cheers

 

[excelquestion123]

Hi,

I have reformatted my attempt at displaying my excel spreadsheet.

----------column a ---column b --- column c --- column d --- column e<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Row 1 ----------------sell price --- client a ---- client b -----client c<o></o>
Row 2----Product 1 ----- $10 ---------4----------- 5 <o></o>
Row 3 ---product 2 ------$25 ---------5 ----------10 ---------15 <o></o>
Row 4 ---Product 3 ----- $40 ---------5<o></o>
Row 5 ---Product 4------ $15--------------------- 10---------- 6<o></o>
Row 6 requires the formula---------- $365--------- $??--------- $??<o></o>

 

[mancemonster]

Hi,


=SUMPRODUCT($B$2:$B$5,C2:C5)

If you put this in C7, and drag across to E7 you should get the desired results.


Regards

Roger

 

[excelquestion123]

Thank you very much.

Works perfectly.