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
|