Try simplifying the formula as I suggested, leaving out the count
statement. =sum(A1:A20) is all you need to total a column. If the
answer is zero, then the cell will be blank.