Then I think that you are stuck with individually adding them.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Blackcat" wrote in message
...
The sheets are in different workbooks though and because of the
distribution
need to stay there.




"Bob Phillips" wrote:

Try

=SUM(Sheet2:Sheet9!A1)

just change the names to your first and last sheet

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Blackcat" wrote in message
...
I have approx 20 workbooks whcih are set up identically.

I need to add the data per cell ( eg A1+A1+A1 etc) in a summary
workbook
but
because of the number of workbooks it's unmanageable to simply add
each
cell.

Is there a simple way of doing this using "SUM" or whatever?

Thanks for any help