Running Total In Column C Based On Date Change in Column B

[inosent1]

I have this example

Amount	Date	Total
100	9/12/2023
200	9/12/2023	300
150	9/13/2023
350	9/13/2023	500

250	9/14/2023
350	9/14/2023	600

I need a formula for the Total column that when the date changes I get a total for that day only

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	Amount	Date	Total
2	100	12/09/2023
3	200	12/09/2023	300
4	150	13/09/2023
5	350	13/09/2023	500
6	250	14/09/2023
7	350	14/09/2023	600
Sheet4

Cell Formulas
Range	Formula
C2:C7	C2	=IF(COUNTIFS(B$2:B2,B2)=COUNTIFS(B:B,B2),SUMIFS(A:A,B:B,B2),"")

 

[inosent1]

Works, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.