Hi,

Can't say as I follow this, your first date is a tuesday the other three are
Fridays on Sheet2?

But based on your formula you should use this

=SUMPRODUCT(--($B6:$B24=A1-6),--($B6:$B24<=A1),$A6:$A24)

Where the dates are in B6:B24 and the numbers in A6:A24 and A1 has the end
of the week you want to total


If this helps please click the Yes button.
--
Thanks,
Shane Devenshire


" wrote:

Can someone help me to get weekly data from Shee1 to Sheet 2 under end
of week date? I triad sumif but did not work.

Sheet 1
A1 B1
10/1 9
10/2 10
10/3 10
10/4 8
10/5 6
10/6 7
10/7 Weekends 12
10/8
10/9


Sheet2
A1 B1
C1 D1
10/7 10/17
10/24 10/31
Sumof week value from B1(62)

Thanks