| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I average a range which also contains empty cells
I am attempting to average a column of numbers; however, some cells in the
column are blank. Is there any means of using the average formula that will calculate the correct average to that will also incorporate the empty cells? Tom Pensacola, FL |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete all empty cells in a range | Excel Worksheet Functions | |||
| average formula ingoring empty cells | Excel Worksheet Functions | |||
| Checking for empty cells in a range | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| sum next two non-empty cells in a range | Excel Worksheet Functions | |||
Threaded Mode
