SUMIF Question2
 

When using the SUMIF function You have a look-up range,criteria and
sum-range. How can you specify two criteria in two look-up ranges. i.e.
Colomn A1:A100 are sales reps, B1:B100 are products sold and C1:C100 is Price
of sale. So add up all pots sold by Julie. Therefore criteria in A:A is Julie
and in B:B is "Pots" and then add up C:C. What does that formula look like?

=SUMPRODUCT(--(A1:A100="Julie"),--(B1:100="Pots"),C1:C100)
best wishes to Frannie (and her homework project?)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Frannie21" wrote in message
...
When using the SUMIF function You have a look-up range,criteria and
sum-range. How can you specify two criteria in two look-up ranges. i.e.
Colomn A1:A100 are sales reps, B1:B100 are products sold and C1:C100 is
Price
of sale. So add up all pots sold by Julie. Therefore criteria in A:A is
Julie
and in B:B is "Pots" and then add up C:C. What does that formula look
like?

for more details on SUMPRODUCT check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Cheers
JuileD

"Bernard Liengme" wrote in message
...
=SUMPRODUCT(--(A1:A100="Julie"),--(B1:100="Pots"),C1:C100)
best wishes to Frannie (and her homework project?)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Frannie21" wrote in message
...
When using the SUMIF function You have a look-up range,criteria and
sum-range. How can you specify two criteria in two look-up ranges. i.e.
Colomn A1:A100 are sales reps, B1:B100 are products sold and C1:C100 is
Price
of sale. So add up all pots sold by Julie. Therefore criteria in A:A is
Julie
and in B:B is "Pots" and then add up C:C. What does that formula look
like?