Auto generate number in cell

Is it possible to get a number auto generated in a cell based on text entered in another cell?

ie. I enter text in B2 (it can be anything) and this will then generate a number in C2 e.g. 1

I am basically wanting to detail a list of issues but this generate a number so that I can then total up the number of issues I have logged

Thanks for any help you can give me

SSGDSG

Put this formula in C2:

=IF(B2="","",ROWS($1:1))

then copy down. It will appear blank until you enter something in column B. To get the total number of issues, put this formula in D2:

=MAX(C:C)

Hope this helps.

Pete

Glenn and Pete

Thank you very much indeed for your help. Works a treat