| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count blanks in pivot table
How can I count blank cells in a pivot table?
I have a table which socres physical activity of patients and have made a pivot table based on that. Pivot table counts very well the cells which has values, but it igonores the cells where there are no values. So how can I ask pivot table to consider blank cells as well? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I stop showing "blanks" in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table Blanks not displaying properly? | Excel Discussion (Misc queries) | |||
| Pivot Table Count | Excel Discussion (Misc queries) | |||
| How do I fill in pivot table blanks? | Excel Worksheet Functions | |||
| The last row of a pivot table shows blanks, but there is data. | Excel Worksheet Functions | |||
Threaded Mode
