How to add weekly values from Monday to Sunday

[atiq124]

The required results from the below data are: Required Result Week 25 = Batches 25 Week 26 = Batches 40 Data Data - Day No. of Batches 16/06/14 Mon 5 17/06/14 Tue 6 18/06/14 Wed 9 19/06/14 Thu 2 20/06/14 Fri 3 21/06/14 Sat 22/06/14 Sun 23/06/14 Mon 5 24/06/14 Tue 9 25/06/14 Wed 26/06/14 Thu 10 27/06/14 Fri 7 28/06/14 Sat 5 29/06/14 Sun 4 <colgroup><col><col><col></colgroup><tbody> </tbody>

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

 

[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.