| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ignore #NA in average formula
I'm plotting daily results in a data table which sometimes have 0 values. I
have created a formula which replaces the 0 values with #NA ie:=IF(B6,B6,NA()) . This throws off the average formula at the end of the table. Can someone suggest a solution, please? Thanks Rosina |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ignore MAX and MIN values in a set to calculate average | Excel Discussion (Misc queries) | |||
| How to make average function ignore MIN and MAX | Excel Worksheet Functions | |||
| Average calcs - ignore sheets | Excel Worksheet Functions | |||
| How do I ignore cells with errors when calculating an average? | Excel Worksheet Functions | |||
| calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) | |||
![Chart blues[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
