Summing across multiple sheets

Can someone please help.

Im trying to sum across multiple sheet into a 'parent' sheet. Problem is, on each of the 'child' sheets, the range/cell could change either up or down, but still in the same columns. I would want to do this for a number ranges/cell in the parent sheet.I also want to be able to add new child sheets and the parent needs to accommodate this. I might also want to swap the order of the sheets - forward or backwars.

I have a spreadsheet with an example of what I want to do attached.

Any help will be appreciated

Blake 7

I want D13 to sum all of the corresponding cells in the relevant column i.e.year 1 must sum only year 1 from each child sheet, etc. The important thing is - that I must be able to add sheets in at a later date and the parent sheet formulae must be able to add these sheets in automatically, no matter what order they are in i.e sheets 'Property 5' to perhaps 'Property 100'

DonkeyOte
Yes, I would like all sheets, with the exception of the summary sheet to be included (this includes future sheets which I might add, in any particular order). I'm new to VBA, so I wouldnt be comfortable trying to do this/understand yet. Further, Im not sure that its a conditional . . I just want to sum.

Blake 7
My apologies - suitably reprimanded. Yes it should have been D5 and, yes, those are all years 1 to 10 for each tab. The reason that they are not on the same line . . is that, each of those sheets will may have varying amounts of data above it (I havent put the data in yet). In other words 'Property 1' only has 2 rows of data, 'Property 2' has 10 rows and 'Property 3' has 19 rows. I also havent put the formula in, but each "NET OPERATING INCOME" row is supposed to have a SUM formula in it to sum the rows above it. The difficulty is when you need to add a new tab, for instance 'Property 4', you dont want to have to amend the 'Summary' page formula.

The simplest way to sum acroos a range of worksheets is to use the "=sum(First:Last!A1)" formulae.

ie you creat a "blank" worksheet witht he name "first" (for example), and a blank worksheet namned "last" (for example). You positin these at the extreme left (first), and extreme right (last), of the worksheets you want to "sum"...."A1" is the cell reference you want to add.

In addition, you would then need to find a way to ensure that the cell you wanted always appeared in the same cell reference.....maybe by using a "lookupo" function on the top row?


hope this helps ...

Stu

..Hi there,

..agian, by usingn the "Summary / First/ ws1 / ws2 / ws3 / Last" method, you simply add another worksheet in between, and the summary will automatically update.

ie:- "Summary / First/ "new ws" / ws1 / ws2 / ws3 / Last"

Stu

Stu - I understand what you are saying, but what if the cell position that you are summing is not the same in each of those sheets?