Can't do it directly, but there is an easy workaround.


Say column A has in cells A1 thru A12:

table
hat
hat

cat

bat
bat

rat
rat
rat

making a pivot table displays:

Count of table
table Total
bat 2
cat 1
hat 2
rat 3
(blank)
Grand Total 8

and the "real" blanks are not counted. Next to the PT, we can use the
formula:

=COUNTIF(A:A,"") which displays 3

This formula, which counts the blanks, is useful because it specifically
excludes all the blanks from A13 thru A65536


So the answer is to use the PT and an additional cell to display the empties.
--
Gary''s Student - gsnu200738