Anna-

You should use two sheets in the same workbook. Use sheet1 to
summarize your results for printing and Sheet2 to input the daily
numbers .

Set up sheet2 (your data) something like this:

1 A B C D E
F G H
2 1/1/2005 1/2/2005 1/3/2005 1/4/2005 1/5/2005 1/6/2005 1/7/2005
3 Item A 7 5 3 8 9 1 4
4 Item B 3 5 9 0 2 4 6

Set up Sheet1 (summary for presentation) as follows:

A B C
1 1/2/2005
2 Cur Mo MTD
3
4 Item A 5 12
5 Item B 5 8

where Cell A1 contains the report date,

The current month column uses the following formula:

=SUMIF(Sheet2!B$2:I$2,Sheet1!$A$1,Sheet2!B3:I3); copy this formula
down

Use the following array formula in the month-to-date column:

{=SUM(IF(Sheet2!B$2:I$2<=Sheet1!$A$1,Sheet2!B3:I3, 0))}; copy this
formula down

Note that this is an array formula - do not type the braces "{}", Excel
will enter these for you - you will need to type the formula and press
Ctrl-Shift-Enter to make it work.

By setting up your worksheet this way you can "recreate" any day of the
month by entering a date into cell A1 on Sheet1.

Also, on Sheet2 enter the first day of the month in Cell B2, then in
column C2 enter the formula =B2+1 and copy this to subsequent columns.
That way when creating the worksheet for the next month you only need to
enter the new month's starting date in B2.

-Terry


--
pthillegas
------------------------------------------------------------------------
pthillegas's Profile: http://www.excelforum.com/member.php...o&userid=16836
View this thread: http://www.excelforum.com/showthread...hreadid=393112