link few worksheets in one summary sheet



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



Roger Govier


To summarise cells C5 from each sheet, to a cell B7 in a Summary sheet, you
should enter in B7 of the Summary sheet

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question