Hi

It is a little unclear from your posting as to how your data is set out.
You say you want to add data from Other sheets, to give a month to data
total. What about part weeks, to make up a month, or are you working on
13 x 4 week periods rather than months?

Could you post some more detail about how each sheet is set out?


--
Regards

Roger Govier





CP wrote
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