Consolidating worksheets

EvansB2

Board Regular
Joined
Nov 25, 2008
Messages
245
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have a number of worksheets that are all identical in terms of format, structure, etc. They are templates and have numbers in them. I have created a summer sheet so I can sum all the numbers in to totals. This summary shee is simply one of the templates but blank.

I there a easier way to sum the values instead of physicaly adding and linking the cells? I know doing it this way won' take long as I can simply drag the formula down and across. But I remember that I came across a more sophisticated way that also didn't involve running a macro in VBA.

Any assistance would be gratefully recieed.

Regards

Ben
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Hi Ben,
depending on your structure this might work:
=SUM(Apr:Jun!B6) -> this should sum up all cells B6 in the sheets Apr, ???, Jun
This formula assumes:
-the first sheet is named "Apr", the last "Jun"
-the number of sheets in between is not fixed (so one sheet named "May" is logical, but you can have multiple)
-it would add up all the cells B6 in those sheets
-if your sheet names have spaces or are numbers, you might need [] or '' around the sheet names, e.g. =SUM(‘(9):(27)’!D7)

Hope that helps,
Koen
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,279
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top