Formula to sum values from cells that have the same date.

[ionut.tepeneu]

Hello all, I'm kinda new to excel and to start learning I have made a personal expense worksheet that grew in complexity along with my grasp of Excel. First of all english is not my native language so please ignore my spelling. I think my problem is pretty simple, I want to display in a cell the sum of a few cells that are from the same day. My table looks like this:

[pre]

DATE    SOLD   SPENT   INCOME   REMAINING   DAY'S TOTAL
3/25    1000   10       0        990          22
990     12       0        978
3/26    978     8        0        970          8
3/27    970     20       0        950          35
950     15       0        935
935     0       115       1050
3/28    1050    25       0        1025         25

[/pre]
Can't figure out a formula that in the DAY'S TOTAL column would sum the amount in SPENT under the same date.

Can anyone help me in this please.

 

[Hui]

Ionut.tepeneu


I would rearrange things a little bit

Put a date in every cell in Column A

[pre]

DATE	SOLD	SPENT	INCOME	REMAINING DAY'S TOTAL
Mar-25	1000	10	0	990
Mar-25	990	12	0	978	22
Mar-26	978	8	0	970	8
Mar-27	970	20	0	950
Mar-27	950	15	0	935
Mar-27	935	0	115	1050	35
Mar-28	1050	25	0	1025	25

[/pre]

Then in F2 put

=IF(A3<>A2,SUMIFS($C$2:$C$8,$A$2:$A$8,A2),"")

Copy down

This puts the days total at the end of each day

 

[ionut.tepeneu]

Thanks a lot, that worked just the way wanted.