How to add weekly values from Monday to Sunday

[atiq124]

[TABLE="width: 409"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]The required results from the below data are:

Required Result
Week 25 = Batches 25
Week 26 = Batches 40


Data

[TABLE="width: 409"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Data - Day[/TD]
[TD] [/TD]
[TD]No. of Batches[/TD]
[/TR]
[TR]
[TD]16/06/14 Mon[/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]17/06/14 Tue[/TD]
[TD][/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]18/06/14 Wed[/TD]
[TD][/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]19/06/14 Thu[/TD]
[TD][/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]20/06/14 Fri[/TD]
[TD][/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]21/06/14 Sat[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22/06/14 Sun[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23/06/14 Mon[/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]24/06/14 Tue[/TD]
[TD][/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]25/06/14 Wed[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]26/06/14 Thu[/TD]
[TD][/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]27/06/14 Fri[/TD]
[TD][/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]28/06/14 Sat[/TD]
[TD][/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]29/06/14 Sun[/TD]
[TD][/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

You layout is not entirely clear. For your first row, is this part...

16/06/14 Mon

in one or two cells?

 

[atiq124]

Actually, it was one column and I used the format as 'dd/mm/yyyy ddd'

 

[Weazel]

looking at your expected results I'm thinking your weeks start on Monday?

If that's the case then maybe something like...

=SUMPRODUCT(--(WEEKNUM(--A2:A15,2)=25),B2:B15)

though you'd need to adjust the '25' for different weeks

 

[atiq124]

Amazing and perfect.
Exactly what I wanted, saved me so much time.
Thank you so much for your time and help, Rick.
Much appreciated.

 

[Rick Rothstein]

Amazing and perfect.
Exactly what I wanted, saved me so much time.
Thank you so much for your time and help, Rick.
Much appreciated.

I think you should be thanking Weazel, not me.

 

[atiq124]

Thank you so much for the previous answer, it's been very helpful.

Another similar question please.
How do we sum up the values for each date, e.g. from the data below, how do we get result of 16/06/14 = 17, 17/06/14 = 10 and so on...

[TABLE="class: cms_table, width: 409"]
<tbody>[TR]
[TD]Date[/TD]
[TD][/TD]
[TD]Value [/TD]
[/TR]
[TR]
[TD]16/06/14

[/TD]
[TD][/TD]
[TD]5
6
6[/TD]
[/TR]
[TR]
[TD]17/06/14 [/TD]
[TD][/TD]
[TD]6
1
3

[/TD]
[/TR]
[TR]
[TD]18/06/14 [/TD]
[TD][/TD]
[TD]9
2
3

[/TD]
[/TR]
[TR]
[TD]19/06/14 [/TD]
[TD][/TD]
[TD]2
3
5

[/TD]
[/TR]
[TR]
[TD]20/06/14 [/TD]
[TD][/TD]
[TD]3
3
4

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Thank you so much for the previous answer, it's been very helpful.

Another similar question please.
How do we sum up the values for each date, e.g. from the data below, how do we get result of 16/06/14 = 17, 17/06/14 = 10 and so on...

[TABLE="class: cms_table, width: 409"]
<tbody>[TR]
[TD]Date[/TD]
[TD][/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]16/06/14
[/TD]
[TD][/TD]
[TD]5
6
6[/TD]
[/TR]
[TR]
[TD]17/06/14[/TD]
[TD][/TD]
[TD]6
1
3
[/TD]
[/TR]
[TR]
[TD]18/06/14[/TD]
[TD][/TD]
[TD]9
2
3
[/TD]
[/TR]
[TR]
[TD]19/06/14[/TD]
[TD][/TD]
[TD]2
3
5
[/TD]
[/TR]
[TR]
[TD]20/06/14[/TD]
[TD][/TD]
[TD]3
3
4
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Questions...

1) Are the three values shown in each "box" meant to indicate that those three values are in a single cell separated by Line Feed characters (generated by pressing ALT+ENTER)?

2) If so, will each cell always contain three values? If not, what is the maximum number of values per cell?

 

[atiq124]

All values are in next row and there could be 1-10 rows under each date. I tried to upload the file or image but do not know how to do that...
So, it will be like:

[TABLE="class: cms_table_cms_table, width: 409"]
<tbody>[TR]
[TD]A2= 16/06/14[/TD]
[TD][/TD]
[TD]C2 = 5
C3 = 6
C4 = 6[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

All values are in next row and there could be 1-10 rows under each date. I tried to upload the file or image but do not know how to do that...
So, it will be like:

[TABLE="class: cms_table_cms_table, width: 409"]
<tbody>[TR]
[TD]A2= 16/06/14[/TD]
[TD][/TD]
[TD]C2 = 5
C3 = 6
C4 = 6[/TD]
[/TR]
</tbody>[/TABLE]

So then, the date is not repeated in cells A3 and A4 meaning A3 and A4 are blank, correct?