Sum values based on date

[KPAW]

I have a spreadsheet where I tack daily expenditure. On a given day I could spend on several items. At the end of that day I want the total of that day's spending in the last row that bear the same date.

For example in the table below, I have the date, amount and total columns.

I want to be able to have a formula in the totals column that look at the dates in the date column, and where the date in a row is different from the date in the row immediately below, sum the values of amounts in rows with the same date and give the total in the last row with the same date.

Date	Amount	Total
10-Mar-12	100
10-Mar-12	112
10-Mar-12	124
10-Mar-12	136
10-Mar-12	220	692
11-Mar-12	232
11-Mar-12	244	476
13-Mar-12	256
13-Mar-12	268	524

<tbody>
</tbody>

I would be grateful for any assistance to find a solution.

 

[Oeldere]

Maybe with a pivot table.

Excel Workbook
	F	G	H	I	J
2		Gegevens
3	date	Sum amount	count amount	Avarage amount	Sum total
4	10-Mar-12	692	5	138,4	692
5	11-Mar-12	476	2	238	476
6	13-Mar-12	524	2	262	524
7	Eindtotaal	1692	9	188	1692
Blad4

 

[Aladin Akyurek]

I have a spreadsheet where I tack daily expenditure. On a given day I could spend on several items. At the end of that day I want the total of that day's spending in the last row that bear the same date.

For example in the table below, I have the date, amount and total columns.

I want to be able to have a formula in the totals column that look at the dates in the date column, and where the date in a row is different from the date in the row immediately below, sum the values of amounts in rows with the same date and give the total in the last row with the same date.

Date	Amount	Total
10-Mar-12	100
10-Mar-12	112
10-Mar-12	124
10-Mar-12	136
10-Mar-12	220	692
11-Mar-12	232
11-Mar-12	244	476
13-Mar-12	256
13-Mar-12	268	524

<tbody>
</tbody>

I would be grateful for any assistance to find a solution.

C2, copied down:

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

 

[T. Valko]

I have a spreadsheet where I tack daily expenditure. On a given day I could spend on several items. At the end of that day I want the total of that day's spending in the last row that bear the same date.

For example in the table below, I have the date, amount and total columns.

I want to be able to have a formula in the totals column that look at the dates in the date column, and where the date in a row is different from the date in the row immediately below, sum the values of amounts in rows with the same date and give the total in the last row with the same date.

Date	Amount	Total
10-Mar-12	100
10-Mar-12	112
10-Mar-12	124
10-Mar-12	136
10-Mar-12	220	692
11-Mar-12	232
11-Mar-12	244	476
13-Mar-12	256
13-Mar-12	268	524

<TBODY>
</TBODY>

I would be grateful for any assistance to find a solution.

Try this...

Enter this formula in C2:

=IF(A2=A3,"",B2)

Enter this formula in C3 and copy down as needed:

=IF(A3=A4,"",SUMIF(A$2:A3,A3,B$2:B3))

 

[KPAW]

Thanks very much for the assistance.