View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alan Alan is offline
external usenet poster
 
Posts: 152
Default How do I count items in another workbook?

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.