count of (blank) pivot table
 

In pivot tables that I create, (blank) is displayed to indicate that there
are blank cells in the range being counted. How do I get it to display the
number of cells in the range that are blank.

Example:

SX 57
Unknown 1
(blank) <----- I want to know how many were blank.
Total 405

count of (blank) pivot table
 

They won't be counted unless you use a space or ="" in the source data

--

Regards,

Peo Sjoblom


"Jtspeakman" wrote in message
...
In pivot tables that I create, (blank) is displayed to indicate that there
are blank cells in the range being counted. How do I get it to display the
number of cells in the range that are blank.

Example:

SX 57
Unknown 1
(blank) <----- I want to know how many were blank.
Total 405