Searching for the correct formula

[dddownie]

I have 12 spreadsheets one for each month of the year on which I track all our expenses. I want to tally a yearly total for all the expenses. The spreadsheets are titled Jan. 2017, Feb. 2017 etc. I want to have all totals on an additional spreadsheet following the same format as the other 12. What formula can I use to total B31, C31, D31, etc. from all spreadsheets on to the total sheet.

 

[Dave Patton]

Insert a sheet before the first relevant sheet and name it Start
Insert a sheet after the last relevant sheet and name it End

Use formulas like =SUM(Start:End!G3)

You could use the above technique without the Start and End sheets.

You could also consider putting all the data on a single sheet which would
let you use Pivot Tables and other formulas.