software

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 quot;For empty cells show 0quot;

Is there a way for the average of columns to count empty cells as 0 and
include them in the average?

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:
gt; I have a pivot table set up that shows how many hours were spent on an
gt; activity in a given month for various people. The source data does not show 0
gt; if there were no hours, there is just no data. In my pivot table, when I
gt; average a column, blank entries are not included in the average, even though
gt; I have quot;For empty cells show 0quot;
gt;
gt; Is there a way for the average of columns to count empty cells as 0 and
gt; include them in the average?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.htmlAny suggestions? (I currently have a macro set up to mirror the data, but it
seems horribly inefficient)

quot;Debra Dalgleishquot; wrote:

gt; For a pivot table average, just like the worksheet Average function,
gt; empty cells are ignored.
gt;
gt; Displaying a zero for empty cells won't affect the average, since it's
gt; an average of the underlying data, not the displayed values.
gt;
gt; Aaron wrote:
gt; gt; I have a pivot table set up that shows how many hours were spent on an
gt; gt; activity in a given month for various people. The source data does not show 0
gt; gt; if there were no hours, there is just no data. In my pivot table, when I
gt; gt; average a column, blank entries are not included in the average, even though
gt; gt; I have quot;For empty cells show 0quot;
gt; gt;
gt; gt; Is there a way for the average of columns to count empty cells as 0 and
gt; gt; include them in the average?
gt;
gt;
gt; --
gt; Debra Dalgleish
gt; Contextures
gt; www.contextures.com/tiptech.html
gt;
gt;