Sumif based on criteria on another cell
 

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

Sumif based on criteria on another cell
 

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

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

Sumif based on criteria on another cell
 

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)


--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
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