subtotal until last row non empty row

[Av8tordude]

I would like to adjust the formula below to not restrict the range. I like to subtotal until the last non empty row when I filter.

="Company ("& SUBTOTAL(3,A15:A1000) & " of " & COUNTA(A15:A1000)&")"

 

[Aladin Akyurek]

Does column consist just only of numbers or text?

 

[Av8tordude]

Text

 

[Aladin Akyurek]

Does column consist just only of numbers or text?

Text

="Company ("& SUBTOTAL(3,A15:INDEX(A:A,MATCH(REPT("z",255),A:A))) & " of " & COUNTA(A15:INDEX(A:A,MATCH(REPT("z",255),A:A)))&")"

 

[Av8tordude]

="Company ("& SUBTOTAL(3,A15:INDEX(A:A,MATCH(REPT("z",255),A:A))) & " of " & COUNTA(A15:INDEX(A:A,MATCH(REPT("z",255),A:A)))&")"

Thank you Aladin for helping. Works great!

 

[Aladin Akyurek]

Thank you Aladin for helping. Works great!

You are welcome. Glad to help.