Thanks:  0
Likes:  0

1. On 2002-04-14 07:03, met wrote:
pls help. i dont know what to do with this. i need total of weekly data.

Col A Col B Col C
04-1 3 04/1-7/02 = 6
04-7 3 04/8-14/02 = 7
04-12 2 04/15-21/02 = 5
04-13 5 04/22-28/02 = 0
04-16 4 04/29-30/02 = 8
04-20 1
04-29 6
04-30 2

met

[ This Message was edited by: met on 2002-04-14 07:04 ]
Too easy! Just add Field names like those below...

******>
 Date Value 04-1 3 04-7 3 04-12 2 04-13 5 04-16 4 04-20 1 04-29 6 04-30 2

... and create a PivotTable with the 'Date' items grouped by Days starting at 4/1/2002, ending at 4/30/2002, and using an interval of 7 days...

******>
 Sum of Value Date Total 4/1/02 - 4/7/02 6 4/8/02 - 4/14/02 7 4/15/02 - 4/21/02 5 4/22/02 - 4/28/02 4/29/02 - 4/30/02 8 Grand Total 26

Also, you'll want to check the "Show items with no data" option on the 'Date' PivotTable Field dialog.

[ This Message was edited by: Mark W. on 2002-04-20 12:37 ]

2. hi to everyone! thanks Dave...the sumproduct formula really works. i appreciate everyone who pitched in. At least now i have different ways to solve this problem.

till next time!!!

met

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•