Pivot Tables--Counting Blank Cells

[CrimsonPlague29]

HI,

I have a similar data type as below

name p/n data to sent y/n response received y/n meet
requirements y/n
john a y y
john b
john c y
john d y y
y
john e n

When I create a pivot table I need the following:

name data sent y data sent n blanks
john 3 1 1

Please advise on how to create.
Thanks

 

[Debra Dalgleish]

Create a pivot table with Name in the row area, Date Sent in the Column
area, and Data Sent in the Data area, as count of Data Sent.
In the pivot table, select the (blanks) heading, and type blanks.

 

[Roger Govier]

Hi
You cannot get a count of blank, as there is nothing to count.
Add another column to your source data in column F called Count with a
formula in F2 of
=IF(C2="y","y",IF(C2="n","n","b"))
Copy down for the extent of your data.
Then with your PT, drag Name to the Row area
Drag Count to the Column area
Drag Count again to the data area