| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ignore zero in subtotal formula
I have the following formula whice averages the cells in column G. However,
some of those cells show a zero, which I would like to ignore. What would I need to add to my formula to accommodate this? =SUBTOTAL(1,G:G) Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore zero in column for subtotal | Excel Discussion (Misc queries) | |||
| how can I ignore or hide the #N/A when doing a sum or subtotal? | Excel Worksheet Functions | |||
| Ignore #N/A in a formula | Excel Discussion (Misc queries) | |||
| Ignore #N/A in a formula | Excel Discussion (Misc queries) | |||
| How can I ignore an #N/A value in a =SUM() formula? | Excel Worksheet Functions | |||
Threaded Mode
