Jane,

SUMIF only works with a single criteria, try eumproduct

=SUMPRODUCT((B1:B100=AD10)*(B1:B100<=AC10)*(C1:C1 00))

Mike

"Jane" wrote:

I am trying to add values in one column, if another column meets a certain
criteria.

This is the formula I have come up with and it doesnt work. Please help

SUMIF(B:B,"<=AC10 and =AD10",C:C )


I thought I posted this question already, but could not find my post on the
forum, so submitting again