Sumif statement

K

knbsmith11

Is there a formula to say if column A = X and if column B = Y, then take the
sum of column C and place it in this cell?
 
R

Ron Coderre

Try something like this:

D1: =SUMPRODUCT((A1:A100=3)*(B1:B100=10)*(C1:C100))

Adds the valued in C1:C100
where the corresponding Col_A value is 3
and the corresponding Col_B value is 10

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
S

SteveG

Assuming your range is A1:C5,

=SUMPRODUCT((A1:A5="X")*(B1:B5="Y")*C1:C5)

HTH

Stev
 
D

Dave O

Yes- try this formula:
=SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y"),C1:C10)

The -- you see are unary operators that cause Excel to evaluate 1 when
a cell in A1:A10 is x and when B1:B10 is y. Other cells in those range
evaluate as zero when they do not match. The SUMPRODUCT multiplies the
rows in C1:C10 by 1 or 0 to derive the sum.
 
T

Toppers

If you want to look at the columns use the following as SUMPRODUCT doesn't
allow you specify column as (e.g.) A:A

=SUMPRODUCT(--(A1:A65535=value1),--(B1:B65535=value2),--(C1:C65535))
 
Top