Pivot Table Question

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!
 
D

Debra Dalgleish

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.
 
Top