John,

Although this may not be the most efficent way of approaching this, I
think that the attached excel file works for you but you'll have to
check it out. It is dependent upon the fact that your raw data where
you are extracting from remains consistent meaning it will always show
each weeks data in order as you have it in your example. The CHOOSE
function acts on an index number that the MATCH function creates by
returning the relative position of the date in the header of the data
you are pulling from so in this case, Feb-24 is the first position.
The CHOOSE function then applies the correct SUMPRODUCT function based
on that. Each SUMPRODUCT function is assigned an index starting with 1
in ascending order each separated by a comma.

Just a suggestion, if you need to post an attachment, do so in excel
not PDF. I had to convert this to excel to try and provide you a
solution.

HTH

Steve


4463


+-------------------------------------------------------------------+
|Filename: SumProduct Table.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4463 |
+-------------------------------------------------------------------+

--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=521899