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. 

 

Paultsip_2-1621441895442.png

 

 

Paultsip_1-1621441822983.png

 

 

1 Reply

@Paultsip 

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