View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Help with cell function[_2_] Help with cell function[_2_] is offline
external usenet poster
 
Posts: 33
Default counting data from one workbook to another

Definetely appreciate your help with this Bob.

I actually gave incorrect information. This is what I have:
The sheet I need the infromation from is "case management stats
(combined).xls and I need to count rows c31:q31.
The sheet that I need the info to go to is 'high risk monitoring list.xls

Thanks Again

"Bob Umlas" wrote:

=SUM('[case management stats]911'!A29:Q29)

"Help with cell function"
wrote in message ...
I have a workbook "high risk list" and a workbook " case management stats"
In
the high risk list, I have a sheet called 911 calls. I need to count the
numbers in the cells of the case management sheet. A29 through q29 have
numbers from 1 to 9 that I need added up in the 911 calls sheet.

"Bob Umlas" wrote:

ummmmm.... what????


"Help with cell function"

wrote in message
...
How do I count data from one workbook to another? Thanks, Burt