Sumif based on criteria on another cell
It worked ... Thank you Mike!!!
"Mike H" wrote:
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
|