countif and subtotal

[kevinfalcon]

=SUMPRODUCT(SUBTOTAL(2,OFFSET(A3,ROW(A3:A1000)-ROW(A3),0)),--(A3:A1000<="*"))

i am trying to use this formula to count cells just with text, but getting no results, HELP!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUMPRODUCT(SUBTOTAL(103,OFFSET(A3,ROW(A3:A1000)-ROW(A3),0)),--(A3:A1000<>""))

 

[kevinfalcon]

Hi & welcome to MrExcel.
How about

=SUMPRODUCT(SUBTOTAL(103,OFFSET(A3,ROW(A3:A1000)-ROW(A3),0)),--(A3:A1000<>""))

EUREKA!!! thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.