| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating Averages but excluding zero's
Hi, i want to calculate the average of a column but exclude anyzeros in that column. For example: If column A1 contained 2, 2, 0, 2, 2, 0 then the average would be 2. (8/4) NOT (8/6) Thanks. -- fodman ------------------------------------------------------------------------ fodman's Profile: http://www.excelforum.com/member.php...o&userid=31941 View this thread: http://www.excelforum.com/showthread...hreadid=555103 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating weighted averages | Excel Discussion (Misc queries) | |||
| Calculating averages excluding outliers...a question | Excel Worksheet Functions | |||
| Calculating basic averages...a question | Excel Worksheet Functions | |||
| calculating averages | Excel Discussion (Misc queries) | |||
| EXcluding Zeros from the average in a row | Excel Discussion (Misc queries) | |||
Threaded Mode
