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

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

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

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

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