| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
EXcluding Zeros from the average in a row
HI
I am trying to average a row of numbers (F35:U35) that have numeric zeros in some of the cells. However, I would like to exclude them, and the cells from the calculation "=AVERAGE(F35:U35)". Is there a way to do that? Thanks -- Geo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a way to hide zeros in a line graph | Charts and Charting in Excel | |||
| Formula to average ignoring negatives? | Excel Discussion (Misc queries) | |||
| Average Macro | Excel Discussion (Misc queries) | |||
| How to show zeros (0) as "slashed" to eliminate confusion with "O. | Excel Discussion (Misc queries) | |||
| average on rows | Excel Discussion (Misc queries) | |||
Threaded Mode
