| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to average a column of numbers that are greater than 0?
this is an array formula that must be entered/edited using ctrl+shift+enter
=AVERAGE(IF(E1:E210,E1:E21)) -- Don Guillett SalesAid Software "JimNColorado" wrote in message ... I am trying to average a column of numbers. I want to only average the cells that contain a number greater than 0. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Typing the name and the column and getting an average (for sales people) | Excel Discussion (Misc queries) | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Average of numbers in column between to other numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
