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