A pivot table can't count blanks. You could type a space character in
those cells, or use a formula: =""
Then, they'll be counted.
Ant wrote:
Hi,
I have a Pivot table pulling data from another workbook.
It's displaying a count for given values in 2 columns.
It's fine for most of the data, but when one of the columns is blank, it
shows a count of 0, even though there are items that are blank.
If I double click on the field, it shows me a sheet that contains the data
that isn't being counted. Is this a bug in the Pivottable? Is there a way
around it?
Thanks.
Ant
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html