Finding values 'between values'
 

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

Finding values 'between values'
 

use sumproduct

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

=SUMproduct((F13:F112=20)*(f13:f112<=49.99)*C13:C 112)


--
Don Guillett
SalesAid Software

"Greg" wrote in message
oups.com...
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

Finding values 'between values'
 

Thank you very much Don, great help!!


Don Guillett wrote:

use sumproduct

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

=SUMproduct((F13:F112=20)*(f13:f112<=49.99)*C13:C 112)


--
Don Guillett
SalesAid Software

"Greg" wrote in message
oups.com...
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

Finding values 'between values'
 

glad to help

--
Don Guillett
SalesAid Software

"Greg" wrote in message
ups.com...
Thank you very much Don, great help!!


Don Guillett wrote:

use sumproduct

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

=SUMproduct((F13:F112=20)*(f13:f112<=49.99)*C13:C 112)


--
Don Guillett
SalesAid Software

"Greg" wrote in message
oups.com...
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