Getting the count of columns in row A from a separate Excel file

[benplace]

If I use =COUNTA(A:A) in my spreadsheet I get a count of columns in row A with data in them.
I need to do the same but pull from an external file.
The following returns a 1 even though the external file has 232 rows in Column A.
=COUNTA('C:\Temp\[test.xlsx]Sheet1'!A:'C:\Temp\[test.xlsx]Sheet1'!A)

It seems to me that it should work...
I am sure the gurus here will have a quick fix for a beginner such as myself..
Thanks in advance!

[Pete_UK]

Try it like this:

=COUNTA('C:\Temp\[test.xlsx]Sheet1'!A:A)

Hope this helps.

Pete

[benplace]

That did it! I knew it was something simple, thanks Pete_UK!