| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I average a range which also contains empty cells
The AVERAGE function does not get upset by empty cells.
-- David Biddulph Tom wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I average a range which also contains empty cells
Tom,
=SUM(A1:A10)/10 Mike "Tom" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I average a range which also contains empty cells
To include empty cells and assign them a value of 0:
=SUM(A1:A10)/ROWS(A1:A10) -- Biff Microsoft Excel MVP "Tom" wrote in message ... 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 |
| Reply |
| 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 | |||
Hybrid Mode
