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
 
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

Similar Threads

Copy Cells from multiple Worksheets in same workbook. 2
Summing up various Worksheets to one Summary sheet using variables 1
Populate Data from Summary Sheet 5
Worksheet Names is Defined by Cell value on Sheet 1 (named Summary 7
Transferring data from multiple worksheets to a Summary sheet 2
summary page of many worksheets 1
extract data from multple worksheets to a summary worksheet 1
Summarise data from several worksheets in a workbook 2

Top