In the Row area of the pivot table, add the field that you want to count
In the data area, add a different field, such as patient name, that will
always contain a value.
This will give you the count of records that have a blank in the field
that's in the row area.


Khoshravan wrote:
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?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html