counting blank cells via pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top