HOW DO I COUNT CELLS WITH DATA BY COLUMN?

[Guest]

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

 

[Scoops]

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

Hi Warren

COUNTA(A1:A10) (or any other specified range) does exactly what you
want.

What formula have you entered to be counting the whole sheet?

Regards

Steve

 

[Franz Verga]

Nel post *Warren* ha scritto:

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

Hi Warren,

You can use COUNTA function also on just one column, I don't know how many
data do you have per column, so it should be better if you insert some empty
row before your data, say to insert two rows, and say you have also headers
in row 3, you could type in A1 =COUNTA(A2:A65536) and copy across the
columns, so B1 should be =COUNTA(B2:B65536) and so on.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy