Can a Pivot Table show a count for all rows where any of 6 fields are blank?

[SandsB]

My file has about 20 columns. I want to do something that shows me if there's either a blank or a zero in column D, E, F, G or H. But not counting row 1 which is a headings row.

I'd like to do this in a pivot table, if possible. But if I tell it to show me a count of all records where there's a 0 or a blank in column D, when I tell it to show me a count of all rows where there's a 0 or blank in column E it olnly shows me where there's a blank in both columns. By the time I do this for all 5 I have no results.

 

[Derek Brown]

I don't think that a Pivot Table is the best way to do this and you would need to update the data range when rows added etc. and refresh the pivot table when data changes.
You did not say which version of Excel is being used.
Excel 2007 has COUNTBLANKS and COUNTIFS.