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

Occasional Visitor

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. 








1 Reply


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