Counting Blank Cells in Pivot Table

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
 
D

Debra Dalgleish

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.
 

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

Pivot Table counting a range 1
Pivot Table 2
Adding to an existing Pivot Table 7
pivot table counting 1
Pivot table filter list - listing irrelevant subcategorys 1
Totaling blank cells in Pivot Tables 8
Pivot Table 1
display all row fields in pivot table 1

Top