View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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