How to create a formula for weighing and summing an undefined number of rows?

bergen

New Member
Joined
Sep 28, 2011
Messages
31
Hello,

I am looking for help to crack this one: I want to calculate the total discount to customers based on discounts on individual products. However the number of products vary from each customer. How can I do this fast and automatic in excel? (And I am stuck with a column in between the two useful columns)

Below I will show you a sample of what information I have:
ABCD
Product NameDiscount %N/AQuantity
Product A47%X10
Product B46%X4
Product C59%X224

<tbody>
</tbody>

I was thinking something like this: =(B3*D3)+(B4*D4)+(B5*D5)/(D3+D4+D5)/3
But clearly I am bad at math since this doesn't give me anything close to 50.5%. And even if it did this formula does not allow for adding or subtracting products.

Can anyone help?
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,089,668
Messages
5,409,630
Members
403,273
Latest member
Yandos

This Week's Hot Topics

Top