Thanks for replies. I think I couldn't express my question clearly. I found
the answer to my question in the following link:
http://www.mrexcel.com/archive2/35200/40546.htm
The blank cells reside on the count of patient column of the PT not on the
row area.
The solution is that to select al blank cells in this area and replace them
with "" and then the blank column header will be counted.
Thanks for your replies.


"Debra Dalgleish" wrote:

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