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


Bill Jelen is the author / co-author of
Power Excel With MrExcel - 2017 Edition

This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.