Well, your range only covers A1:A2, so I'm not sure how you think that
is going to return 100 !!

The correct syntax would be:

=COUNTA([workbook.xls]:worksheet!a1:a200)

assuming the workbook is open - otherwise you would need the full path
before the [. You might need to wrap the path, filename and sheet name
within apostrophes if you have spaces in that string.

Hope this helps.

Pete

On Jan 22, 9:43*pm, Alan wrote:
It's referencing another workbook that's confusing me. *When counting items
in another worksheet I'm using COUNTA(worksheet!a1:a2) and I get a valid
number. *However, when counting items in another workbook I'm using
COUNTA(workbook:worksheet!a1:a2) and my response is "1". *The count should be
over 100. *What am I doing wrong?

Thanks.