make text in one cell count as 1 in another cell

J

jenny

Hi, In would like to know please, if I fill in cells with text, how can I
make each of them them count numeric in another cell. i.e B2 james, B3
julia, C4= 2
 
Z

Zeb

In C4 put the formula =counta(B2:B3) This will count all the cells from B2 to
B3 that have text in the cell, if you want to count a specific value then you
can use the countif function.

Zeb
 
B

Bondi

jenny said:
Hi, In would like to know please, if I fill in cells with text, how can I
make each of them them count numeric in another cell. i.e B2 james, B3
julia, C4= 2
Click to expand...

Hi Jenny,

If you put in cell C4

=COUNTA(B2:B3)

It counts the cells that are non-empty... ( So it will also count if
the contents in the cells is numeric.)

Regards,

Bondi
 
R

RagDyeR

To count non-blank (filled with anything) cells:
=CountA(B:B)

To count only numbers:
=Count(B:B)

To count only text:
=Countif(B:B,"*?")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi, In would like to know please, if I fill in cells with text, how can I
make each of them them count numeric in another cell. i.e B2 james, B3
julia, C4= 2
 
Top