Finding values 'between values'

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
 
Top