Values in cells
Sorry, I posted in wrong place. Annoying. *need coffee*
Good Morning y'all! I hope this message finds you well and enjoying a lovely Monday morning I am working on a workbook that has two worksheets. Worksheet one is named "Master" and worksheet two is named, "Combined"
On the Master worksheet in column E12281 I have =SUM(E2:E12280) equaling $2,363,835.42
On the Combined worksheet in column D235 I have =SUM(D2:D234) equaling $2,363,835.42
The Sum of these two columns should always match. The "Master" spreadsheet has more detail for each Store and the "Combined" just has totals per store.
Is there a formula that I can use that will change the total on the "Master" when I add to column D on the "Combined" worksheet?
Thank yall in advance for everything yall do. It is AWESOME!!!
Last edited by Paperdoll; 02-21-2011 at 12:18 PM. Reason: Posted new thread in wrong place
Please excuse me if I've misunderstood, but it sounds like you want to change cell Master!E12281 from it's original formula of:
to simply:=SUM(E2:E12280)
While that may answer the question, it doesn't seem to be what you might want. Would you please elaborate?=Combined!D235
Cheers,
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks