Sumif based on criteria on another cell

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

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
 
Jane,

SUMIF only works with a single criteria, try eumproduct

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

Mike
 
It worked ... Thank you Mike!!!



Mike H said:
Jane,

SUMIF only works with a single criteria, try eumproduct

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

Mike
Click to expand...
 
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)
 
Back
Top