How do I count items in another workbook?

[Alan]

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.

 

[Pete_UK]

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

 

[Dave Peterson]

=COUNTA([book2.xls]Sheet1!$A$1:$A$2)
or
=COUNTA([book2.xls]Sheet1!A1:A2)

I'd let excel do the work.

Open the other workbook.
Then in the cell that's going to contain the formula, type:
=counta(
And then go to the "sending" sheet and select the range.

Excel will use absolute references ($A$1 instead of A1), but you can use F4 to
cycle through the reference styles.