Combine SUMIF and SUMPRODUCT
See if this does what you want.
=SUMPRODUCT(--(A2:A5="Category1"),B2:B5*C2:C5)
HTH,
Paul
"Tevuna" wrote in message
...
Here is how the data is setup:
A B C
Type Qt. Rate
Category1 5 $10.00
Category2 6 $2.00
Category1 .5 $.50
Category2 10 $7.00
Here is the objective:
Calculate total amount, by mulitplying Qt. and Rate, if Category =
category1
SUMPRODUCT doesn't take an argument for condition, and SUMIF can't
multiply.
Is there a formula that combines them both?
|