| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why does (blank) display on pivot table | Charts and Charting in Excel | |||
| count of totals for pivot table | Excel Discussion (Misc queries) | |||
| How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
| Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
Threaded Mode
