how to calculate sumproduct if row below is different than current row

[LIC_xls]

I've attached a link to a data table. Here's what I'm trying to do. For each cell in column G, I need to calculate the revenue-weighted average price of the product lines EXCLUDING the product line associated with the row of the cell that I am calculating in column G. Cell G2 is a manual example of what I need to calculate in an automated way. For example, in G4 I need to calculate the weighted average price for product lines C and D--so the Revenue % needs to only capture E7:E11. Can you please help me create a formula for this?

 

[MrRapidwolf]

Hi,

can you share screenshot? i can`t find your link

 

[LIC_xls]

I've attached a link to a data table. Here's what I'm trying to do. For each cell in column G, I need to calculate the revenue-weighted average price of the product lines EXCLUDING the product line associated with the row of the cell that I am calculating in column G. Cell G2 is a manual example of what I need to calculate in an automated way. For example, in G4 I need to calculate the weighted average price for product lines C and D--so the Revenue % needs to only capture E7:E11. Can you please help me create a formula for this?

Here is the link: Average Price

 

[LIC_xls]

Hi,

can you share screenshot? i can`t find your link

Here is the link: Average Price

 

[LIC_xls]

I've attached a link to a data table. Here's what I'm trying to do. For each cell in column G, I need to calculate the revenue-weighted average price of the product lines EXCLUDING the product line associated with the row of the cell that I am calculating in column G. Cell G2 is a manual example of what I need to calculate in an automated way. For example, in G4 I need to calculate the weighted average price for product lines C and D--so the Revenue % needs to only capture E7:E11. Can you please help me create a formula for this?

Screenshot

 

[Fluff]

Is this what you want

=SUMPRODUCT(($A$2:$A$11<>A2)*($C$2:$C$11)*($E$2:$E$11))/SUMIFS($E$2:$E$11,$A$2:$A$11,"<>"&A2)