Thread
:
Finding values 'between values'
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett