Need help with formula

[fwilkins46]

I'm sure this will be very simple to someone else, but I am old now and can't remember how.
A. B. C
Actual Sales. Forecast. Gain/Loss
Daily 600. 500. . 100
WTD. 1200. 1000. 200
MTD. 1800. 1500. 300
If I change the amount in daily sales and daily forecast, I want Week to date and Month to date to change automatically without me having to add it manually.

 

[sandy666]

Duplicate

Need formula

I'm sure this will be very simple to someone else, but I am old now and can't remember how

www.mrexcel.com

 

[fwilkins46]

I'm sure this will be very simple to someone else, but I am old now and can't remember how.
A. B. C
Actual Sales. Forecast. Gain/Loss
Daily 600. 500. . 100
WTD. 1200. 1000. 200
MTD. 1800. 1500. 300
If I change the amount in daily sales and daily forecast, I want Week to date and Month to date to change automatically without me having to add it manually.

I'm so sorry, forgot my little spreadsheet on the first one. Thank you.

 

[sandy666]

You've 10 minutes to edit, modify and save your own post