S Sia F Oct 19, 2003 #1 Please tell me how to sum a cell such as 'C5' from many worksheets onto 'C5' cell of total worksheet. Thanks.
Please tell me how to sum a cell such as 'C5' from many worksheets onto 'C5' cell of total worksheet. Thanks.
A Aladin Akyurek Oct 19, 2003 #2 Insert two new woksheets, name them First and Last, put all the relevant worksheets between First and Last, and use in your Total worksheet: =SUM(First:Last!C5)
Insert two new woksheets, name them First and Last, put all the relevant worksheets between First and Last, and use in your Total worksheet: =SUM(First:Last!C5)
