I need a formula that will count cells with data (text data) by cell range
within a column. COUNTA will do this, but only for the whole sheet. I need
something to count the number of cells in column A with data and total it,
then count the number of cells in column B with data and total it... etc.
Essentially, like a sum function only I don't need any numbers added within a
range, I just need the spreadsheet to total how many cells in a range have
data. The numbers in the example of what I need (below) should, I hope, be
the result of the formula. I need to remove some human error in totaling the
number of people I have named on a spreadsheet for a head count. Microsoft
Excel 2003. SP2

COLUMN A COLUMN B COLUMN C
NAME NAME NAME
NAME NAME NAME
NAME NAME NAME
NAME
3

3 4 NAME
NAME
NAME
NAME


4