| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need average of numbers that occur within range
I need help writing a formula that calculates the average number that
occurs within a range of numbers. For example, I have a column that contains 500 rows. Each row contains a random number between 1 and 100. I want to only extract numbers that fall between the range of 1-10 and than compute the avg number that occurs between 1-10. Thanks, Brian |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average a group of numbers within an date range. | Excel Worksheet Functions | |||
| Identify numbers that only occur once in a column. | Excel Worksheet Functions | |||
| Average of select range of numbers | Excel Worksheet Functions | |||
| Average the first nine numbers in a range. | Excel Discussion (Misc queries) | |||
| Average first n numbers in a range (there may be less than n numbe | Excel Discussion (Misc queries) | |||
Threaded Mode
