WEEKNUM to dynamic range name

Well,

I believe that was the answer. I had already created the column of WEEKNUM and basically applied your suggestion of SUMIF and it looks like it is working.

Thanks!

Can you think of a way to do it without creating the column of WEEKNUM's? and maybe incorporating it into the SUMIF?

Thanks for your help.

=SUMPRODUCT(--(1+INT(($A$2:$A$366-(DATE(YEAR($A$2:$A$366),1,2)
-WEEKDAY(DATE(YEAR($A$2:$A$366),1,1))))/7)=week_to_test),B$2:B$366)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"additude" <additude.2beh84_1153661407.7212@excelforum-nospam.com> wrote in
message news:additude.2beh84_1153661407.7212@excelforum-nospam.com...
>
> Well,
>
> I believe that was the answer. I had already created the column of
> WEEKNUM and basically applied your suggestion of SUMIF and it looks
> like it is working.
>
> Thanks!
>
> Can you think of a way to do it without creating the column of
> WEEKNUM's? and maybe incorporating it into the SUMIF?
>
> Thanks for your help.
>
>
> --
> additude
> ------------------------------------------------------------------------
> additude's Profile:
http://www.excelforum.com/member.php...o&userid=36661
> View this thread: http://www.excelforum.com/showthread...hreadid=564085
>

Originally Posted by Bob Phillips

=SUMPRODUCT(--(1+INT(($A$2:$A$366-(DATE(YEAR($A$2:$A$366),1,2)-WEEKDAY(DATE(YEAR($A$2:$A$366),1,1))))/7)=week_to_test),B$2:B$366)

That's why I said that a column with WEEKNUM was the easiest way...
....although I think you can simplify Bob's suggestion very slightly to

=SUMPRODUCT(--(INT(($A$2:$A$366-DATE(YEAR($A$2:$A$366),1,1)-WEEKDAY($A$2:$A$366))/7)+2=week_to_test),B$2:B$366)