| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get "AVERAGE" function to ignore empty cells
Excel 2007.
I have 3 columns of data where the daily amount over the month is posted by a formula relating to another sheet in the same book. Below each column I want to display the daily Average of the data in that column. When the data was typed into the columns (cells) the "AVERAGE" function worked okay. However, now that the data is called up via a formula, the "AVERAGE" calculates across all 31 cells in the column, including those with no data yet posted. Can someone tell me how I get the "AVERAGE" function to ignore the empty cells. TIA for any help. Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Excel to ignore "a", "an", "the" when sorting? | Excel Discussion (Misc queries) | |||
| How do I ignore "#N/A" data in a column while calculating average | Excel Worksheet Functions | |||
| Cannot find "Plot empty cells as" option in 2007 | Charts and Charting in Excel | |||
| syntax for "IF" commend to check for multiple empty cells bf comma | Excel Worksheet Functions | |||
| "Empty" values in holiday parameter for NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
