The pivot table that does not count the blanks is based on two non-numeric
fields in the Row area and a Count of one of those fields in the Column area.
The pivot table that counts the blank fields is the same but only one
non-numeric field in the Row and a count of that field in the Column.

"Debra Dalgleish" wrote:

The difference is what field is in the data area.
What field is in your pivot table's data area, and what field is in the
other pivot table's data area?

mtg girl wrote:
If the pivot table can't count blank cells, can you explain why the 2nd
example I sent counted the blank cells? The 2nd example is a pivot table I
received from someone else. It apears to be set up the same as mine,
counting non-numeric fields (in a column) that contains blanks. These fields
are truly blank as indicated by the (blank); however, this pivot table
counted 7505 records.

I have deleted the pivot table and recreated it, but all my pivot tables do
the same thing. We both work at the same company, so the versions of excel
are the same.

I can't figure out what is different between the 2nd example and the one I
created.

"Debra Dalgleish" wrote:


The pivot table can't count blank cells, so if you put a field (e.g.
Reply) in the row area, and Count of Reply in the data area, the (blank)
item will show nothing in the data area.

However, if you add a different field to the data area, you may see the
correct count. For example, if the Date field always has a value, add
that to the data area, and summarize by Count. The pivot table will then
show the count of records with a blank Reply field.


mtg girl wrote:

I have a Pivot Table that shows blank cells but does not calculate the number
of cells. There are 3 records with blanks.
No 262
Yes 2
(blank)
Grand Total 264

In a Pivot Table I received from someone else, the blank fields are totaled.
Shanna Cleveland 10
Soraya Guzman 2
Steve Vitale 1
(blank) 7505
Grand Total 7709

I have checked the Table Options and both Pivot Tables have a check mark in
the "for empty cells, show:". I can not figure out what else might be
different between the two tables. Also, both workbooks have "Zero Values"
checked in the Tools/Option/View.



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





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