I'm new to using Excel and have a simple chart I need help with.
it's shown below:
E F G (etc.....for 52 weeks!)
1 YEAR TO DATE BUDGET: 3508.47 7106.94 10525.41
2
3 RECEIVED YEAR TO DATE: 4167.64 6012.64 8678.64
4
5 WEEKLY OFFERING BUDGETED: 3508.47 3508.47 3508.47
6
7 RECEIVED LAST WEEK: 4167.64 1845 2666
Line 5 will remain 3508.64 for the duration of the report.
I'll input the amount into line 7 every week.
I need to have E1 added to 5E & put in F1.
and 3E added to 7E and the total be put into F2
How can I make that happen?
Thank you for your help!!!
Bookmarks