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