| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In a pivot table, can the avg of a column include rows w/o data?
I have a pivot table set up that shows how many hours were spent on an
activity in a given month for various people. The source data does not show 0 if there were no hours, there is just no data. In my pivot table, when I average a column, blank entries are not included in the average, even though I have "For empty cells show 0" Is there a way for the average of columns to count empty cells as 0 and include them in the average? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a pivot table, can the avg of a column include rows w/o data?
For a pivot table average, just like the worksheet Average function,
empty cells are ignored. Displaying a zero for empty cells won't affect the average, since it's an average of the underlying data, not the displayed values. Aaron wrote: I have a pivot table set up that shows how many hours were spent on an activity in a given month for various people. The source data does not show 0 if there were no hours, there is just no data. In my pivot table, when I average a column, blank entries are not included in the average, even though I have "For empty cells show 0" Is there a way for the average of columns to count empty cells as 0 and include them in the average? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In a pivot table, can the avg of a column include rows w/o dat
Any suggestions? (I currently have a macro set up to mirror the data, but it
seems horribly inefficient) "Debra Dalgleish" wrote: For a pivot table average, just like the worksheet Average function, empty cells are ignored. Displaying a zero for empty cells won't affect the average, since it's an average of the underlying data, not the displayed values. Aaron wrote: I have a pivot table set up that shows how many hours were spent on an activity in a given month for various people. The source data does not show 0 if there were no hours, there is just no data. In my pivot table, when I average a column, blank entries are not included in the average, even though I have "For empty cells show 0" Is there a way for the average of columns to count empty cells as 0 and include them in the average? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
Linear Mode
