Chris asks: How do I add the number of cells in a column and then divide into the dollar total of that column to get my percentage close ratio?

To count the number of numeric cells in a column, use =COUNT(A1:A99).
To count the number of alpha or numeric cells in a column, use =COUNTA(A1:A99).
You can combine functions in a formula: =SUM(A1:A99)/COUNTA(A1:A99)