| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding values and displaying adjacent values | Excel Worksheet Functions | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| Finding (Multiple) Highest Values in Column | Excel Worksheet Functions | |||
| Finding number of values in a range on a per year basis | Excel Worksheet Functions | |||
| Finding unique values with Criterias | Excel Discussion (Misc queries) | |||
Linear Mode
