| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of cells in a column
Hi
How can I write a function Average of cells in a column but not count hiden cells? Normally I write: Average(D:D) but this function will calculate average all cells even hiden cells In my spread sheet I have some hiden cells such as below Cell in row 1 2 3 4 100 101 102 .... i just want to calculate average of cell 1,2,3,4,100,101,102 but skip cells in row 5 to 99 Thanks Daniel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I average more cells only in a column by a criteria? | Excel Worksheet Functions | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| calculate average in a column based on criteria in another column | Excel Discussion (Misc queries) | |||
| Sum/average numbers in column A dependant on value in column B | Excel Worksheet Functions | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Threaded Mode
