Values in cells

[Paperdoll]

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!!!

[ConneXionLost]

Please excuse me if I've misunderstood, but it sounds like you want to change cell Master!E12281 from it's original formula of:

Please Login or Register  to view this content.

to simply:

Please Login or Register  to view this content.

While that may answer the question, it doesn't seem to be what you might want. Would you please elaborate?

Cheers,