Sumif based on value in cell

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

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
 
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.
 
Back
Top