TODAY() and the totals for that day

[Guest]

I'm trying to get my "daily" totals on one sheet to total on a "weekly" sheet.
What I want is for, ex. January 1, 2007 - January 7, 2007 = "Week 1" and to
take the totals from those days and apply them to my "Week 1" cells.

any ideas
Brett

 

[macropod]

Hi Brett,

Assuming your data sheet (Sheet1) has dates in column A (A$1:A$1000) and values in column B (B$1:B$1000) and your summary sheet is
to aggregate the weekly data in columns A & B, which are formatted like:

Week Ending Total
7/01/2007 ###

then you could put an array formula like:
=SUM(IF((Sheet1!A$1:A$1000<A2)*(Sheet1!A$1:A$1000>A2-8),Sheet1!B$1:B$1000,))
in column B of the summary sheet.

Cheers

--
macropod
[MVP - Microsoft Word]


| I'm trying to get my "daily" totals on one sheet to total on a "weekly" sheet.
| What I want is for, ex. January 1, 2007 - January 7, 2007 = "Week 1" and to
| take the totals from those days and apply them to my "Week 1" cells.
|
| any ideas
| Brett

 

[Guest]

Thank you for your help