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