Counting Blank Cells in Pivot Table

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

How do I have a Pivot Table count the blank cells as well
as the other cells? The Pivot table I created counts
everything that had data (A, B, C, D, etc...) but does not
count the blank cells.

Thank you,

Jack
 
As answered in microsoft.public.excel.charting:

To count the blanks you could use a space character, or the formula ="",
in the source data, instead of leaving the cells blank. The pivot table
will be able to count those.
 
Back
Top