Hi,

The spreadsheet I am working is one that is done daily with a weekly recap
of a total of certain codes. What I want to do is have the Month to Date
total of the codes be automatic without having to link it to all the other
weekly spreadsheets.

For example: A1=1 (for week 1, 2 for week 2, etc.)

=if (A1=1,a2+?,?) (A2 would represent the total of that code for that week)

My sheet will total the codes for that week, but how do I automate adding
Week 1's totals to Week 2's totals etc. for a Month to Date total?

Right now, I am having to manually add the current week with the past weeks
totals to get the Month to Date total.

Any ideas?

Thanks, CP