i have 7 worksheets ( identical in size ) - for different days and I want to
create a sumarry sheet i.e. cell B7 in the summary sheet to sum cells C5
from each worksheet ( in the same workbook ). Then having five workbooks ( or
worksheets )i.e.five weeks , to summarize them in one grand summary book (
monthly ) and then the final move is to make the year book ( 12 month in one
)Please help . I tried =sum( sheet1:sheet7!B7) in sheet10 cell K4 and it did
not work

Hi

To summarise cells C5 from each sheet, to a cell B7 in a Summary sheet, you
should enter in B7 of the Summary sheet
=SUM(Sheet1:Sheet7!C5)

--
Regards
Roger Govier

"Corneliu" wrote in message
...
i have 7 worksheets ( identical in size ) - for different days and I want
to
create a sumarry sheet i.e. cell B7 in the summary sheet to sum cells C5
from each worksheet ( in the same workbook ). Then having five workbooks
( or
worksheets )i.e.five weeks , to summarize them in one grand summary book (
monthly ) and then the final move is to make the year book ( 12 month in
one
)Please help . I tried =sum( sheet1:sheet7!B7) in sheet10 cell K4 and it
did
not work