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