Sorry about that, too good to be true. As Daniel says, the fact that it
doesn't work is a flaw in the implementation of the WEENIE function.

Daniel's formula works, but whilst it has a more immediate test that Arvi
and Biff's solutions, it is not as intuitive. I tried (and failed :-)) to
provide a more elegant solution, which didn't work, so I would go with your
first solutions.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don" wrote in message
...
Hi Bob,
I like your formula but I cannot get it to work. Does it work for you?

I get #value

"Bob Phillips" wrote in message
...
As an alternative, if you could use


=SUMPRODUCT(--(WEEKNUM(Sheet1!$A$2:$A$100)=WEEKNUM(A2)),Sheet1!$ D$2:$D$100)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dominique Feteau" wrote in 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?