Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
=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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |