I can't seem to get Excel to calculate the number of blank cells in the
fields of my pivot tables. They acknowledge that the blank cells exist, but
won't calculate how many.

I've looked at every option, and don't see a way to turn this function on
(years ago this used to be defaulted to being on). Can anyone assist?

Thanks much...

The pivot table can't count blank cells, so if you put a field (e.g.
Product) in the row area, and Count of Product 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 Order 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 product field.


Robbo wrote:
I can't seem to get Excel to calculate the number of blank cells in the
fields of my pivot tables. They acknowledge that the blank cells exist, but
won't calculate how many.

I've looked at every option, and don't see a way to turn this function on
(years ago this used to be defaulted to being on). Can anyone assist?

Thanks much...


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