As per this
http://office.microsoft.com/en-us/ex...CH010004401033

COUNTA will total only non blank items. I need to Count blanks also. What
option is available for this in Pivot tables?

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.

Guru wrote:
As per this
http://office.microsoft.com/en-us/ex...CH010004401033

COUNTA will total only non blank items. I need to Count blanks also. What
option is available for this in Pivot tables?



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