I am trying to get my spreadsheet to COUNT (not SUM) entries in a specific column, but i need it to NOT count cells if their data reads "0". Since the cells in this column have their own SUM formulas, they aren't being left blank.
Is that doable? What would the formula look like?