Month to date calculations
=SUM($A$1:A1)
copied down
will sum A1, then A1:A2 then A1:A3
is that what you want?
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
Portland, Oregon
"CP" wrote in message
...
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
|