In a pivot table, can the avg of a column include rows w/o data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Any suggestions? (I currently have a macro set up to mirror the data, but it
seems horribly inefficient)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Total of 2 columns in pivot table 5
Average of % in pivot table 1
Pivot Table Average Problem 2
Excel Sumproduct 0
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table 3
Pivot table, average of nex column 1
Average of Subtotals in Pivot Table 0

Back
Top