link few worksheets in one summary sheet


C

Corneliu

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
 
Ad

Advertisements

R

Roger Govier

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)
 

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

Top