Hi everyone,
I've been trying to develop a calculation sheet where I can divide a fixed price through several products. The "program cost" should be divided by all the lines sharing the same value in a certain column according to a weighted average presented by another column.
Explaining:
Column C: Initial Price;
Column F: Quantity;
Column I: Program;
Objective: Aggregate products by their program;
Divide the program cost (10€) by all of them considering their weighted average cost.
I can't apply the weighted average function in the formula you see in my picture.
Hope you've understand my problem and thank you in advance!
EXCEL DOUBT.PNG
Bookmarks