software

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?

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-Proquot;knbsmith11quot; wrote:

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


Assuming your range is A1:C5,

=SUMPRODUCT((A1:A5=quot;Xquot;)*(B1:B5=quot;Yquot;)*C1:C5)

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=530581Yes- try this formula:
=SUMPRODUCT(--(A1:A10=quot;xquot;),--(B1:B10=quot;yquot;),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.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))

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; D1: =SUMPRODUCT((A1:A100=3)*(B1:B100=10)*(C1:C100))
gt;
gt; Adds the valued in C1:C100
gt; where the corresponding Col_A value is 3
gt; and the corresponding Col_B value is 10
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;knbsmith11quot; wrote:
gt;
gt; gt; Is there a formula to say if column A = X and if column B = Y, then take the
gt; gt; sum of column C and place it in this cell?