Pivot Tables w/ blanks

K

Keith

Can anyone help me. I am using pivot tables to sort out survey data that has numeric values. The data I'm using has no response in some cases which leaves the cell blank. My pivot table will sort and count the data that has values fine but when the cell is blank the only counts I get are 0(zero).

Sample Data:

Reason for visit?
3
2

1
1
3

2
3

1

table results
1 = 3
2 = 2
3 = 3
blank = 0

blank should = 3

Thanks in advance for any help.
 
K

Keith

Yes Debra that worked... thank you very much!

Debra Dalgleish said:
Do you have other fields in the list, that have a value in each row?
For example, if another column contains a date, add that field to the pivot table's Data area, as 'Count of Date', and remove the 'Reason for visit' field from the data area.
Click to expand...
 
K

Keith

Maybe I spoke too soon. Your suggestion worked great for the 1st pivot table but the other pivot tables want to include all the data. I have close to 10 pivot tables on this spreadsheet. How do I choose my current column and the date column 2 or 3 columns over? Can I choose random columns or do they have to touch each other?
 
D

Debra Dalgleish

Include all the columns in the pivot table source range, but only
display the fields you need in the pivot table. For example, the source
range might be A1:M5000, but pivot table only shows the fields in
columns B and H.
 
Top