• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dynamic Sum Across Sheets


I need help making my "Summary" tab only Sum the formulated cells but only on certain tabs. Preferably every tab to the right of it if possible. I would say to make it sum all but I have an assumptions page that is essential to the sheet for multi-year projections. Hoping it will not be VBA but I will take what I can get.

Side note: This will be for multiple groups. Tabs will be added and deleted over time. But the summary page needs to make sure it is adjusting to that. Thanks again!

Please help! Thanks!


Last edited: