Dynamic Addition with multiple sheets
Hey guy, im new here and im starting off with a doozy of a question.
I was wondering if theres anyway of adding up the same cell of every sheet without having to manualy reference them all. Also is it possible for the fumula to effect sheets added after?
EG;
I want F3 to equal the sum of every G3 and all future G3's?
Cheers guys.
Last edited by kwinza; 02-25-2010 at 06:40 AM.
See this link: SUM ALL SHEETS
Scroll down the page a bit to see the relevant information.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
I've tryed using =SUM('Start :Spacer'!G3) but it doesn't work for some reason
This link is a bit more helpful: Summing Values across Worksheets
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks