I forgot something. In the case management workbook, i have a sheet called
september 2009, that is the sheet that has the info I need. Thanks

"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