| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating the average of cells
I am trying to use a formula to calculate the average of random cells
currently containing data, however also including cells where data will be added at a later date but remain empty. Is this possible? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating the average of cells
On Mon, 13 Mar 2006 12:53:27 -0800, pippa
wrote: I am trying to use a formula to calculate the average of random cells currently containing data, however also including cells where data will be added at a later date but remain empty. Is this possible? =average(<range1,<range2...) will work quite happily with blanks and non numeric values but will not accept cells with calculation errors (not a problem if all your cells are just data) -- Steve |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculating the average of cells
Many thanks Steve
"SteveW" wrote: On Mon, 13 Mar 2006 12:53:27 -0800, pippa wrote: I am trying to use a formula to calculate the average of random cells currently containing data, however also including cells where data will be added at a later date but remain empty. Is this possible? =average(<range1,<range2...) will work quite happily with blanks and non numeric values but will not accept cells with calculation errors (not a problem if all your cells are just data) -- Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Average non-adjacent cells question... | Excel Discussion (Misc queries) | |||
| 30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
| average of spaced cells | Excel Worksheet Functions | |||
| Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Hybrid Mode
