View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bondi Bondi is offline
external usenet poster
 
Posts: 94
Default 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