MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting Cells with Specific Content


January 11, 2002 - by Bill Jelen

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