| Home |
| Search |
| Today's Posts |
|
#10
|
|||
|
|||
Hi Biff, Thank you very much - your Formula works well too. Thanks Sam Biff wrote: =SUMIF(A1:E1,"<#N/A")/COUNTIF(A1:E1,"0") -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200507/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using The Average Function if a cell has NA | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Auto average function | Excel Worksheet Functions | |||
| average function in Excel 2002 | New Users to Excel | |||
| I want to use the MATCH function with the AVERAGE function but I . | Excel Worksheet Functions | |||
Threaded Mode
