How to reference an entire row based on an indirect cell reference

I'm trying to create a function which will return the number of entries in the row of the last entry in a given column. What I'm specifically trying to do is run a COUNTA function on the entire row of the last filled cell in column A. I tried to write a function which referenced this row indirectly, but the way I wrote the function returns the reference in text format and the function returns an error. See Below:

Please Login or Register  to view this content.

Any suggestions?

Hi

Try

Please Login or Register  to view this content.

rylo

Perfect

Thanks

I was going to suggest a non-volatile version:

=COUNTA(INDEX(A:A,COUNTA(A:A)):INDEX(ZZ:ZZ,COUNTA(A:A)))

change ZZ to last column used (or beyond)