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