Sumif based on criteria on another cell

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
 
M

Mike H

Jane,

SUMIF only works with a single criteria, try eumproduct

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

Mike
 
J

Jane

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
 
T

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top