| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
work book on Excel 07
I want to average a group of percentages but want to exlude cells which have
the value 0 (some of the cells have 0 for the numerator and denominator). What would the formula be? What I have so far is =(F10+F13+F16+F19+F22+F26+F30)/7 What I want to do is exclude F19 for example if its value is 0 rather than 0%. Any suggestions? Thanks much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel work book | Excel Worksheet Functions | |||
| Splitting an excel work book in to two | Excel Discussion (Misc queries) | |||
| excel work book | Excel Discussion (Misc queries) | |||
| Excel work Book Order | Excel Worksheet Functions | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
