Hi!
If you have the week ending date all you need to do is
subtract 6 to get the week starting date.
On your sheet2 assume you have the week ending date in
cell A2. The formula would be something like this:
Assume:
Sheet1 Col A = dates
Sheet1 Col C = form
Sheet1 Col D = number
=SUMPRODUCT(--(Sheet1!A2:A20=A2-6),--(Sheet1!A2:A20<=A2),-
-(Sheet1!C2:C20="whatever"),D2:D20)
Biff
-----Original Message-----
I have a sheet that has nothing but data. Columns a
Date, Employee, Form,
Number
On another sheet, i want to add the total of "numbers"
per "form" per week
from the "date"
now the date on the first sheet is daily. on the second
sheet its "week
ending".
how do i set up the formula to add up only those for a
certain week?
.
|