countA formula

[khalil]

=COUNTA(A101:INDEX(A:A,LOOKUP(2,1/(A2:A101="Table"),ROW(A2:A101))+1))

i have this formula , it counts like what i want ,
But it counts also the blank cells including formulas....no text yet!
is there any cod to add to it, in order to prevent the unnecessary count,


thanks

 

[Misca]

Try:

=COUNTA(A101:INDEX(A:A,LOOKUP(2,1/(A2:A101="Table"),ROW(A2:A101))+1))
-COUNTIF(A101:INDEX(A:A,LOOKUP(2,1/(A2:A101="Table"),ROW(A2:A101))+1),"")

Not tested.

 

[Aladin Akyurek]

Duplicate of: http://www.mrexcel.com/forum/showthread.php?t=557795

 

[khalil]

thanks
i tried it ,

but it lost the way it should count

 

[Peter_SSs]

Duplicate locked.