| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Computing averages excluding values with no value
I am trying to figure out an average for a range of cells but I do not want
the cell used in the calculation if there isn't a value. I am using it for YTD (year to date) averages and do not want to have to go and change it after every month. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Computing averages excluding values with no value
AVERAGE ignores blank cells (but includes cells with zero) so if the cells
are blank, you can AVERAGE the whole of your range. "j_jimenez420" wrote: I am trying to figure out an average for a range of cells but I do not want the cell used in the calculation if there isn't a value. I am using it for YTD (year to date) averages and do not want to have to go and change it after every month. Any help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Computing averages excluding values with no value
Thanks! Looks like I am just overthinking again. Appreciate the help!
"Toppers" wrote: AVERAGE ignores blank cells (but includes cells with zero) so if the cells are blank, you can AVERAGE the whole of your range. "j_jimenez420" wrote: I am trying to figure out an average for a range of cells but I do not want the cell used in the calculation if there isn't a value. I am using it for YTD (year to date) averages and do not want to have to go and change it after every month. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averages excluding zeros | Excel Discussion (Misc queries) | |||
| Calculating Averages but excluding zero's | New Users to Excel | |||
| Calculating averages excluding outliers...a question | Excel Worksheet Functions | |||
| Averages excluding certian data | Excel Discussion (Misc queries) | |||
| Averages excluding #N/A | Excel Discussion (Misc queries) | |||
Hybrid Mode
