View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aaron
 
Posts: n/a
Default 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?