Need a formula here

agonysWeeper

Board Regular
Joined
Feb 4, 2011
Messages
146
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?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

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

Watch MrExcel Video

Forum statistics

Threads
1,108,708
Messages
5,524,428
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top