Need a formula here

[agonysWeeper]

sheet2 Column A (Product Name), Column D (Price), Column F (Status which Sold and Available).
Sheet1 D18=Product Name F18= a formula I am looking for (formula which is calculating/looking for all same product name and summing all price that only sold.

anyone help?

 

[VoG]

Try

=SUMPRODUCT(--(Sheet2!A1:A100=D18),--(Sheet2!F1:F100="Sold"),Sheet2!D1:D100)

 

[Ganjin]

nevermind xD

 

[agonysWeeper]

Hi Mr Vog, works here, thanks