| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Calculate Average of an Array of Data for numbers less than 22, while ignoring blanks
I need to calculate the average (and STD) of 4000+ numbers while excluding all values greater than 22 as well as excluding blanks. Because the number of data points fluctuates, I wanted to input a huge number of rows into the formula to deal with this inconsistency (hence ignoring the blank cells). Perhaps there is a better way.
Any help is greatly appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate average from non contiguous column, ignoring (0) values | Excel Worksheet Functions | |||
| Criteria average ignoring blanks | Excel Discussion (Misc queries) | |||
| Criteria average ignoring blanks | Excel Discussion (Misc queries) | |||
| Calculate the average of numbers, ignoring multiple values | Excel Discussion (Misc queries) | |||
| Conditional Average Ignoring Blanks | Excel Worksheet Functions | |||
Hybrid Mode
