Sumproduct Multiple criteria same column

[vsr_shimla]

Pls help I want to find the Weighted average of the following data in a single column :
I have tried Sumproduct(--(Heads="Freight")*(Value),(Heads="Sale")*(Value))/Sum(Sale)

COUNTY Heads Value
A Sale 200
A Freight 35
A Distance 50
B Sale 300
B Freight 50
B Distance 100
C Sale 200
C Freight 35
C Distance 50


Regards

 

[vsr_shimla]

Thanks the result is perfect, my problem solved.
Rgds

 

[vsr_shimla]

I multiplied All Sale fields with All Freight fields and Divided by Sum of Total Sales
Rgds

 

[DanteAmor]

Formula in E2
=SUMIF(B:B,"Sale",C:C)

Formula in G2 copied down
=SUMPRODUCT((B$2:B$8="sale")*C$2:C$8,(B3:B9=F2)*C3:C9)/E$2

M.

Thanks Marcelo, I got a little lost, because I never understood what data should add and multiply (or never explained )

 

[Marcelo Branco]

Thanks Marcelo, I got a little lost, because I never understood what data should add and multiply (or never explained )

Yes, initially I did not understand either, but observing the desired results I suggested a formula. Looks like I got it right

M.