Can anyone see why this formula won't work?
=SUMPRODUCT((WEEKNUM(DataClerkDay)=WEEKNUM(E67))*(DataClerkCustShip))
It's a modification of this formula, which DOES work:
=SUMPRODUCT((MONTH(DataClerkDay)=MONTH($E$1))*(DataClerkDistShip))
The named range "DataClerkDay" refers to a column of 32 days, like:
12/1
12/2
12/3
etc
Range "DataClerkDistShip" is a column of numbers
Cells E67 and E1 in their respective formulas
refer to date criteria like "12/1/02" or 12/15/02".
Any help is appreciated, I'm sort of new to sumproduct formulas.
Thanks!
((EDIT: cell is reporting a #value error. a value in formula is wrong data type))
This message was edited by ChrisM on 2002-12-31 09:10
=SUMPRODUCT((WEEKNUM(DataClerkDay)=WEEKNUM(E67))*(DataClerkCustShip))
It's a modification of this formula, which DOES work:
=SUMPRODUCT((MONTH(DataClerkDay)=MONTH($E$1))*(DataClerkDistShip))
The named range "DataClerkDay" refers to a column of 32 days, like:
12/1
12/2
12/3
etc
Range "DataClerkDistShip" is a column of numbers
Cells E67 and E1 in their respective formulas
refer to date criteria like "12/1/02" or 12/15/02".
Any help is appreciated, I'm sort of new to sumproduct formulas.
Thanks!
((EDIT: cell is reporting a #value error. a value in formula is wrong data type))
This message was edited by ChrisM on 2002-12-31 09:10