Sumif based on criteria on another cell

[Jane]

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

 

[Mike H]

Jane,

SUMIF only works with a single criteria, try eumproduct

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

Mike

 

[Jane]

It worked ... Thank you Mike!!!

Jane,

SUMIF only works with a single criteria, try eumproduct

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

Mike

 

[T. Valko]

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

Assuming:
AC10 is your upper boundary value
AD10 is your lower boundary value

=SUMIF(B:B,">="&AD10,C:C)-SUMIF(B:B,">"&AC10,C:C)