Return a value when Any text is in a specific cell

[Traderlew]

This is the fomula I want to put in the cells A2:A10
IF(B2=Text,A1+1," ")
IF(B3=Text,A2+1," ")

The red "Text" is what I don't know how to enter for it to work in the formula.

I simply want to have the cells in column A have numbers beginning with 1 only if there is Text in the respective cells in Column B.

I'm using Excel version 1905

Thank you for any help.

Lew

 

[Fluff]

Hi & welcome to MrExcel.
How about
=IF(ISTEXT(B2),N(A1)+1,"")

 

[kweaver]

Try this in A2 and fill down:

=IF(ISTEXT(B2),MAX($A$1:A1)+1,"")