I have a column where each cell has either a X or is blank. I would like to
count the number of X's and then return a percentage complete based on the
number of cells total (X's and blanks).

I also have another column, but this column has all different characters
(not just a X) I would still like to count the cells with data and give an
average based on number of cells total (X's and blanks).

Thanks in advance