Hi everyone,

I have a problem with the above functions. Here is what I have:
A B C
1 7 2010 x

The formula I have is:
=SUMPRODUCT((WEEKNUM(Range1)=$A1)*(YEAR(Range1)=$B 1))
=x

The ranges come from another worksheet. I do not want to add a new column in
the raw data worksheet where these ranges are.

Any help would be appreciated and thanks in advance.

Cheers,
Sam.