counting blank cells via pivot table

I

Ilya Kern

I have an IF statement in a sheet which will put "F" in the cell if the criteria is true or "" (blank text) if the criteria is false. I am then running a pivot table over this data and trying to get a count of the F's in the column. The problem is that the pivot table counts both the F's and the "". I have tested this using the COUNTA function with the same result. Any thoughts ?

Thanks & Regards,

Ilya
 
D

Debra Dalgleish

You can use a COUNTIF formula on the worksheet, to count the Fs. For
example: =COUNTIF(C2:C20,"F")

To count the Fs in a pivot table, add that field to the data area,
summarized by Count. Add the field again to the row, column or Page
area, to separate the Fs from the empty strings.
 
Top