Finding values 'between values'

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

Hi all,

Hope someone can give me a hand with an easy one cell calc for finding
values of between values. hopefully it will make more sense when you
read on.

I have a range of price bands (e.g. 0-19.99, 20-49.99, 50-99.99
etc...), attached to these in a different column are the values of
these price ranges.

I have done the first one:

=SUMIF(F13:F112,"<=19.99",C13:C112)

But now, how do I do one for 'between values'.... as excel doesnt
except:

=SUMIF(F13:F112,">=20","<=49.99",C13:C112)

It must be something like this, so it would be saying if it matches
between these prices sum the volumes in C column.

Any help would be gratefully appreciated,

Many Thanks,

Greg
 
You must log in or register to reply here.

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

Getting a value out of a Matrix 4
using sumifs with multiple criteria? 3
How to fix Compatibility error 3
Repeat formula in new rows 4
Chart with different Y axis values 2
Count based on cell value between two numbers 4
Need a help with the IF/ IFCOUNT function 4
SUMIF with defined name as calculated value 3

Back
Top