I have a list of data (5 row items) for multiple fiscal weeks (Column headers) and I need to have a sumary of the values by fiscal week values when the data is first entered in column G and then the ending values of data when the column with the same week number (Column headers) gets down to column B because the fiscal week columns will move to the left until they are complete and fall off the sheet from G to B.

Thank for you help Nunzio