make text in one cell count as 1 in another cell
 

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

make text in one cell count as 1 in another cell
 

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

"jenny" wrote:

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

make text in one cell count as 1 in another cell
 

jenny wrote:
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

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

make text in one cell count as 1 in another cell
 

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!
================================================== ===

"jenny" wrote in message
...
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