Sumif from sheet 1 to sheet2

[tr2usa]

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

 

[tr2usa]

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

{=sum(if(weekday(a1)=Weekday($a$2:$A$366),$b$2:$B$366)}

I tried this formula also but did not work.

 

[ShaneDevenshire]

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.

 

[tr2usa]

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








- 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