Can I use SUMIF with < and >?

C

cursednomore

I have a worksheet with a price field and a cost field. I am trying to sum
the cost field with the condition that the value in the price field is
between two numbers, for example, 300 and 350. Is there a formula that will
aloow me to do that?
 
F

Frank Kabel

Hi
one way:
=SUMIF(A1:A100,">300",B1:B100)-SUMIF(A1:A100,">=350",B1:B100)

or
=SUMPRODUCT(--(A1:A100>300),--(A1:A100<350),B1:B100)
 

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

Similar Threads

Mail Merge Directory Conditional Page Break 0
rounding a number up to a certain ending digit 6
Adding Cost Field to Appointment 0
Use TODAY() function as the criteria in a SUMIF formula 1
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Help on randomly selecting cells to SUM 2
How to implement two shifts per day with multiple teams 0

Top