Formulas

[Simon]

Can anyone help???

I need a formula that counts a cell if there is a name in
there.

EG. A
1 Simon
2 Peter
3 Tom
4
5 Hey

Then formula would return 4.

 

[Frank Kabel]

Hi
try
=COUNTA(A1:A100)