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?
 

Forum statistics

Threads
1,086,030
Messages
5,387,389
Members
402,058
Latest member
disgracept

Some videos you may like

This Week's Hot Topics

Top