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

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

=SUM(E2:E12280)

to simply:

=Combined!D235

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

Cheers,