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]

 

[atiq124]

yes, that's right.
I have previously used a formula like below but can not get it working now:

=sumif(A2:A100,"="&,C2,B2:B100)

it used to sum all the values for date mentioned in C2.
A2:A100 = All dates
B2:B100 = values for each date
C2 = manually entered date and formula cell returned sum of all values in that date.

 

[Rick Rothstein]

yes, that's right.
I have previously used a formula like below but can not get it working now:

=sumif(A2:A100,"="&,C2,B2:B100)

it used to sum all the values for date mentioned in C2.
A2:A100 = All dates
B2:B100 = values for each date
C2 = manually entered date and formula cell returned sum of all values in that date.

It looks like you used different columns for you new question. I will assume the columns you specified in Message #9 (Columns A and C). Given that, put this array-entered** formula in cell D2 and copy it down...

=IFERROR(SUM(C2:OFFSET(A2,IF(A2="","",IFERROR(ROW()+MATCH(1,--(LEN(A3:A$1000)>0),0),1000)-ROW())-1,2)),"")

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

NOTE: Change the two 1000's highlighted in red to a row number guaranteed to be larger than any row you ever expect to have data in.