| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Averaging only visible cells
Thanks very much for your help!! Worked like a champ.
"Gary''s Student" wrote: Yes...use the 101 code -- Gary''s Student - gsnu200786 "Bear Black" wrote: I know there is a subtotal function that will only add up visible cells when using filters, but is there a formula that will average only visible cells when using filters? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging with #N/A Cells | Excel Discussion (Misc queries) | |||
| Averaging 14 Cells | Excel Discussion (Misc queries) | |||
| Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) | |||
| Averaging Cells | Excel Discussion (Misc queries) | |||
| Averaging cells which contain #DIV/0! | Excel Worksheet Functions | |||
Threaded Mode
