count blanks in pivot table

[Guest]

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?

 

[Guest]

Can't do it directly, but there is an easy workaround.


Say column A has in cells A1 thru A12:

table
hat
hat

cat

bat
bat

rat
rat
rat

making a pivot table displays:

Count of table
table Total
bat 2
cat 1
hat 2
rat 3
(blank)
Grand Total 8

and the "real" blanks are not counted. Next to the PT, we can use the
formula:

=COUNTIF(A:A,"") which displays 3

This formula, which counts the blanks, is useful because it specifically
excludes all the blanks from A13 thru A65536


So the answer is to use the PT and an additional cell to display the empties.

 

[Debra Dalgleish]

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.

 

[Guest]

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.