Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on value in cell
I am trying to add values in one column, if the second column matches the
criteria. This is what I have written and I know this is wrong. Can anyone please help. SUMIF(B:B,"<=AC10 and =AD10",C:C) Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on value in cell
Your problem is you are checking for two conditions, not one. Sumif can
handle only one condition. If you have Excel 2007, you can use: =sumifs(c:c,b:b,"<="&ac10,b:b,"="&ad10) If not, you can use Sumproduct, but you can't use an entire column. Something like: =sumproduct(--(b2:b1000<=ac10),--(b2:b1000=ad10),c2:c1000) Regards, Fred. "Jane" wrote in message ... I am trying to add values in one column, if the second column matches the criteria. This is what I have written and I know this is wrong. Can anyone please help. SUMIF(B:B,"<=AC10 and =AD10",C:C) Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on value in cell
Thank you Fred.
This is what I have and the result I get is 0, which is not correct. Do you know what I am doing wrong. SUMPRODUCT((B8:B152<=AD10),(B8:B152=AC10),C8:C152 ) Thanks again "Fred Smith" wrote: Your problem is you are checking for two conditions, not one. Sumif can handle only one condition. If you have Excel 2007, you can use: =sumifs(c:c,b:b,"<="&ac10,b:b,"="&ad10) If not, you can use Sumproduct, but you can't use an entire column. Something like: =sumproduct(--(b2:b1000<=ac10),--(b2:b1000=ad10),c2:c1000) Regards, Fred. "Jane" wrote in message ... I am trying to add values in one column, if the second column matches the criteria. This is what I have written and I know this is wrong. Can anyone please help. SUMIF(B:B,"<=AC10 and =AD10",C:C) Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on value in cell
Fred,
From Mike's post above, I figured the error... Thanks. Jane "Jane" wrote: Thank you Fred. This is what I have and the result I get is 0, which is not correct. Do you know what I am doing wrong. SUMPRODUCT((B8:B152<=AD10),(B8:B152=AC10),C8:C152 ) Thanks again "Fred Smith" wrote: Your problem is you are checking for two conditions, not one. Sumif can handle only one condition. If you have Excel 2007, you can use: =sumifs(c:c,b:b,"<="&ac10,b:b,"="&ad10) If not, you can use Sumproduct, but you can't use an entire column. Something like: =sumproduct(--(b2:b1000<=ac10),--(b2:b1000=ad10),c2:c1000) Regards, Fred. "Jane" wrote in message ... I am trying to add values in one column, if the second column matches the criteria. This is what I have written and I know this is wrong. Can anyone please help. SUMIF(B:B,"<=AC10 and =AD10",C:C) Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif based on value in cell
I don't see Mike's post, but from mine you'll notice dashes (--) in my
formula which aren't in yours. It's a simple matter of not copying the formula properly. Regards, Fred. "Jane" wrote in message ... Fred, From Mike's post above, I figured the error... Thanks. Jane "Jane" wrote: Thank you Fred. This is what I have and the result I get is 0, which is not correct. Do you know what I am doing wrong. SUMPRODUCT((B8:B152<=AD10),(B8:B152=AC10),C8:C152 ) Thanks again "Fred Smith" wrote: Your problem is you are checking for two conditions, not one. Sumif can handle only one condition. If you have Excel 2007, you can use: =sumifs(c:c,b:b,"<="&ac10,b:b,"="&ad10) If not, you can use Sumproduct, but you can't use an entire column. Something like: =sumproduct(--(b2:b1000<=ac10),--(b2:b1000=ad10),c2:c1000) Regards, Fred. "Jane" wrote in message ... I am trying to add values in one column, if the second column matches the criteria. This is what I have written and I know this is wrong. Can anyone please help. SUMIF(B:B,"<=AC10 and =AD10",C:C) Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIf based on date | Excel Discussion (Misc queries) | |||
SUMIF Based On Cell Color | Excel Discussion (Misc queries) | |||
sumif based on cell comparison in excel | Excel Worksheet Functions | |||
sumif-add amount to another cell based on two criteria | Excel Discussion (Misc queries) | |||
SumIf based on two criteria | Excel Worksheet Functions |