| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating total in a range of numbers
I would like to calculate the sum of all values that are greater than 20 and
less 50 in the following data set. Can anyone give me the formula for this computation. 5 5 19 20 22 25 45 51 60 This is what I am after but with a larger data set. 20+22+25+45 = 112 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique RANDOM NUMBERS within specified range | Excel Worksheet Functions | |||
| Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
| how to get a total to add up a range | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Calculating a colmun to total a 40 hour work week | Excel Worksheet Functions | |||
Threaded Mode
