Formula for daily total as day goes along?

[ChetShannon]

I have a workbook with 3 columns. #1 Date, #2 Time, #3 Amt_taken. I am trying to add a 4th column called Amt_taken_so_far. I am unable to calculate the 4th column.

This 4th column is just the sum of column #3 up to that time of the current day for that row. So the column 4 will show the incremental total as the day goes along and then reset for the next day. I am tracking how much food my cat has eaten and want to know as the day goes along the total as the day progresses how much he's eaten. I'm trying to come up with a formula to give me that. The problem has been that column1 and 2 have multiple days in them.

 

[Tom Urtis]

You did not say what row your data actually starts in, so assuming you have header cells in A1:D1, meaning the data of dates, times, and amounts taken start in row 2, then in cell D2 you can enter and copy down

=IF(A2<>A3,SUMIF($A$2:A2,A2,$C$2:C2)-SUMIF($A$1:A1,A2,$D$1:D1),"")

 

[Peter_SSs]

I'm wondering if this might be what you are after?

21 05 22.xlsm
	A	B	C	D
1	Date	Time	Amt	Day Progress
2	20/05/2021	9:00	3	3
3	20/05/2021	11:30	6	9
4	20/05/2021	14:14	5	14
5	20/05/2021	15:45	1	15
6	20/05/2021	20:00	4	19
7	21/05/2021	7:30	2	2
8	21/05/2021	12:01	3	5
9	21/05/2021	16:00	5	10
10	22/05/2021	0:55	4	4
11	22/05/2021	8:03	7	11
Day Progress

Cell Formulas
Range	Formula
D2:D11	D2	=IF(A2=A1,D1+C2,C2)

 

[ChetShannon]

Thank you these were both great answers. I ended up using the simple (2nd one). I should have thought of it myself. Thank you!

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.