Start and Finish Tabs formulas

[trumpetman]

If I have a work book and at the beginning of the worksheets I have Start Tab and then a fnish tab further down and there are 7 tabs with a name of each day on for example between the start and finish tabs. And I have a worksheet after finish with results and I want to add all C20 cells in each of the worksheets to display in the results page. There is a way I used to do a formula of adding all c20 celss up between start and finsish tabs, but can't remember.

Any idea of the formula to do this?

[MarvinP]

Hi trumpetman,

You're looking for something like

Please Login or Register  to view this content.

I built an example of what you described and attached it below. Open it and see if it works for you:
Three D multi tab sum of c20.xlsx

[trumpetman]

Thank you that is great and works. Previous when I used Excel I am sure I had start and finish in the formula to tell it to look at cell c20 on all worksheets between start and finish.

This works as well and poss easier so thank you