sumif question

[brianwa]

Here's what I have
Column A
Material description
Column B
Current Wholesale price
Column C
Qty shipped

I want to sum up products that match both column A & B then sum th
value in column C. Another condition is that the wholesale (column B
needs to be between a certain value, let's say $400 - $499.

Thanks in advance
B

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000="material_criteria")*(B1:B1000>=400)*(B1:B1000<50
0),C1:C1000)

 

[brianwa]

Thanks Frank,

Works like a charm. You guys are always a great help.

Regards
B