Forum Discussion
Pivot Table is counting blanks. Pivot table counting blanks with formulas inside cell.
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).
