Sumif from sheet 1 to sheet2
 

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

Sumif from sheet 1 to sheet2
 

On Oct 17, 4:29*pm, ShaneDevenshire
wrote:
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- Hide quoted text -

- Show quoted text -

Dear Shane,
Thank you taking time to get me this formula, sorry I did not make my
question clear.

I have data on Sheet1, Column A has dates of the week and columns B
has the production hours.

My goal is to get week days working hours summurized under week ending
date in Sheet2 under A1,B1 and ..... Sheet two will have only week
ending days.

Vedat