How to Sum many worksheets into one

S

Sia F

Please tell me how to sum a cell such as 'C5' from many
worksheets onto 'C5' cell of total worksheet.
Thanks.
 
A

Aladin Akyurek

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)
 

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

Calculate end date and time 1
VBA Coding Help for Beginner 0
Conditional Sum across WORKSHEET 6
formula for arriving net difference 0
VLookup sum multiple matches 1
HOW WILL MOVE TO 2ND WORKSHEET 2
Multiple logic functions with multiple sums 2
Autosum returns zero balance - why? 1

Top