I have a pivot table set up to tell me how many hours were incurred during
each month before an event. (Eg. 5 Month Prior: 152 hours, 4 Month Prior: 38
hours.) If no hours are incurred, my data sheet does not show zero, it just
doesn't have anything.

I set the Total Row to be an average of the data, but the average doesn't
pick up records with no hours incurred. (If one program had no hours, the
average will not include that as being zero, it just excludes it from the
average)

Is there a way to have blank entries included in the average? (I already
have empty cells set to display 0)