Pivot Table Question

  • Thread starter Thread starter Betty Csehi
  • Start date Start date
B

Betty Csehi

I've created a pivot table and it works well - counts the number of items in
each category. What it doesn't do is count the number of blank cells. It
gives me a blank category but, alas, it is blank. I want the blank category
line to tell me how many blank cells I have. I know that this is possible,
but just can't seem to make it work. Can someone help? Thanks!
 
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.
 
You must log in or register to reply here.

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

missing value in a pivot table 3
Pivot Table 2
Pivot tables - counting unique numbers 2
Pivot tables - 'blank' label 2
Pivot Table question or a simpler suggestion 2
Count of Non-Zero pivot table entries 1
pivot table (blank) 2
display all row fields in pivot table 1

Back
Top