Sumif statement
 

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?

Sumif statement
 

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


"knbsmith11" wrote:

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?

Sumif statement
 

Assuming your range is A1:C5,

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=530581

Sumif statement
 

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.

Sumif statement
 

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))

"Ron Coderre" wrote:

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


"knbsmith11" wrote:

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?