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