Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif statement | Excel Discussion (Misc queries) | |||
Nested SumIf statement | Excel Worksheet Functions | |||
my sumif statement brings back mutiple answers, how do I fix it? | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
sumif statement | Excel Worksheet Functions |