Getting the sum of column based on equal dates

[msvb6109]

Hello everybody. Monthly, I am making a report wherein I need to get the sum of a column based on specific dates. Attached is extracted sample of the data:
A B C
1 Value Date Amount Sub Total
2 01/04/2012 89,812.10
3 02/04/2012 147,543.00
4 02/04/2012 28,660.00
5 03/04/2012 79,950.92
6 03/04/2012 4,550.00
7 03/04/2012 145,770.00

What I am doing is to use the Sum function on the next column based on the date I need to add. For example, formula for c2 will be =sum(b2:b2), c3 will be blank since I needed to add b3 and b4, i.e., formula for c4 will be =sum(b3:b4), formula for c7 will be = sum(b5:b7).

Is there any way to expedite this process by wrting only one formula in column c that will be applicable to all? Thank you.

 

[VoG]

Maybe like this - formula in C2 copied down

Excel Workbook
	A	B	C
1	Date	Value	Total
2	01/04/2012	89,812.10	89,812.10
3	02/04/2012	147,543.00	176,203.00
4	02/04/2012	28,660.00	176,203.00
5	03/04/2012	79,950.92	230,270.92
6	03/04/2012	4,550.00	230,270.92
7	03/04/2012	145,770.00	230,270.92
Sheet6

 

[VoG]

Or maybe better

=IF(A2<>A3,SUMIF(A$2:A$10,A2,B$2:B$10),"")

 

[msvb6109]

Mr./Ms. VoG,

Thank you very much for your prompt reply. This partly solves my problem. However, I need the sub total to appear in column c once only for every date. Thus, for columns c3, c5 and c6, these should be = to zero/nil. Can you help me on this? Thank you again.

 

[VoG]

Yep - see the second formula that I posted

Excel Workbook
	A	B	C
1	Date	Value	Total
2	01/04/2012	89,812.10	89,812.10
3	02/04/2012	147,543.00
4	02/04/2012	28,660.00	176,203.00
5	03/04/2012	79,950.92
6	03/04/2012	4,550.00
7	03/04/2012	145,770.00	230,270.92
Sheet6

 

[msvb6109]

That is exactly what I needed. This will save me a lot of time. Thank you very much.