| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average for a column to exclude zeros and numbers above 39000
Dear ladies and gents, please help me figure out how to build a formula for a
column of 150 cells, where I need to obtain the average excluding the cells containing zeros and numbers above 39000. I tried =AVERAGE(if(L3:L150<390000, L3:L150,false)) and it gives me a number I am not sure is right. Thank you so much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average of non contigous data to also exclude zeros | Excel Discussion (Misc queries) | |||
| Add numbers in a column, but exclude percentages in the same colum | Excel Worksheet Functions | |||
| Average non-adjacent cells & exclude zeros | Excel Discussion (Misc queries) | |||
| How do I average a column without including zeros | Excel Discussion (Misc queries) | |||
| How to average a column, but exclude zero AND negative values? | Excel Discussion (Misc queries) | |||
Threaded Mode
