# Calculate qty produced each week from daily data

#### PHolt

##### New Member
Hi,

I have 2 worksheets one daily and 2nd for weekly. I look for the week number using WEEKNUM

Daily sheet look like this
 Date Week Number Time Taken Qty Completed Row No 26/02/2013 9 65.00 25 2 26/02/2013 9 435.00 183 3 27/02/2013 9 310.00 500 4 27/02/2013 9 18.00 30 5 28/02/2013 9 165.00 36 6 04/03/2013 10 30.00 3 7 04/03/2013 10 100.00 62 8 05/03/2013 10 weeknum(A9,1) 258.00 124 9 05/03/2013 10 147.00 169 10 05/03/2013 10 159.00 87 11

<TBODY>
</TBODY>

Weekly Sheet

 Week Commencing Week Number Total time taken total qty completed 25/02/2013 9 01/03/2013 10 08/03/2013 11

<TBODY>
</TBODY>

I have tried using a sumif formula, if week numbers match, total the time taken. But this isn't working. For example for calculating week 9 it would also include the data from row 9 because there is a 9 in the weeknum formula.

I think I may have to use SUMPRODUCT, but have never used this before. can some help please?

Thanks
Pam

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### Comfy

##### Well-known Member
Sumif should work:

Excel 2010
ABCDE
1DateWeek NumberTime TakenQty CompletedRow No
226/02/13965252
326/02/1394351833
427/02/1393105004
527/02/13918305
628/02/139165366
704/03/13103037
804/03/1310100628
905/03/13102581249
1005/03/131014716910
1105/03/13101598711
12
13
14
15
16
17
18
19Week CommencingWeek NumberTotal time takentotal qty completed
2025/02/139993774
2101/03/1310694445
2208/03/131100
Sheet1
Cell Formulas
RangeFormula
B2=WEEKNUM(A2,1)
B3=WEEKNUM(A3,1)
B4=WEEKNUM(A4,1)
B5=WEEKNUM(A5,1)
B6=WEEKNUM(A6,1)
B7=WEEKNUM(A7,1)
B8=WEEKNUM(A8,1)
B9=WEEKNUM(A9,1)
B10=WEEKNUM(A10,1)
B11=WEEKNUM(A11,1)
C20=SUMIF(\$B\$2:\$B\$11,B20,\$C\$2:\$C\$11)
C21=SUMIF(\$B\$2:\$B\$11,B21,\$C\$2:\$C\$11)
C22=SUMIF(\$B\$2:\$B\$11,B22,\$C\$2:\$C\$11)
D20=SUMIF(\$B\$2:\$B\$11,B20,\$D\$2:\$D\$11)
D21=SUMIF(\$B\$2:\$B\$11,B21,\$D\$2:\$D\$11)
D22=SUMIF(\$B\$2:\$B\$11,B22,\$D\$2:\$D\$11)

#### PHolt

##### New Member
Thanks, no sure what Id id wrong then

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Threads
1,164,374
Messages
5,836,888
Members
430,460
Latest member
cristian270

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back