View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jtspeakman
 
Posts: n/a
Default 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