Pivot Table is counting blanks. Pivot table counting blanks with formulas inside cell.

[Paultsip]

Having a difficult time creating a pivot table that counts how many items are within each column but only if there is a value in a cell. Instead, the pivot table counts every single cell resulting in every count being the same. 

[#2]

@Paultsip 

PivotTable doesn't count blanks if only cells are really blank, i.e. not contain empty strings "" (usually returned by formulas).