What formula should I use to get total value date wise.

In D3 copied down:

=IF([@Column1]=A4,"",SUM(B$2:B2)-SUM(D$2:D2))

by applying your formula result is not correct.

Sorry - should be this:

=IF([@Column1]=A4,"",SUM(B$2:B3)-SUM(D$2:D2))

AliGW on MS365 Insider (Windows) 64 bit

	A	B	C	D
2	Date	Amount		Total
3	02-01-2022	$ 202.00
4	02-01-2022	$ 200.00
5	02-01-2022	$ 456.00
6	02-01-2022	$ 356.00
7	02-01-2022	$ 345.00
8	02-01-2022	$ 867.00		$2,426.00
9	03-01-2022	$ 454.00
10	03-01-2022	$ 345.00
11	03-01-2022	$ 444.00
12	03-01-2022	$ 346.00		$1,589.00
13	04-01-2022	$ 34.00
14	04-01-2022	$ 267.00		$ 301.00
15	05-01-2022	$ 367.00
16	05-01-2022	$ 43.00
17	05-01-2022	$ 65.00
18	05-01-2022	$ 774.00		$1,249.00

Sheet: Sheet1

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

I want to know why you use [@Column1] in column1 I may write anything instead of Column1 or doesn't use any heading at that scenario what should I use IF([@Column1]=A4
and also why =A4 why not A3

The answer is simply that this is how it works. I'm sorry if you don't like it.

and also why =A4 why not A3

Change it to A3 and you will see why - it won't work. You need to identify where there is a change of date.

Use Evaluate Formula on the Formulas ribbon to see how it works.

Is there any chance you could change the tone of your responses? It's all very curt at the moment - English may not be your first language, but 'please' and 'thank you' are universal courtesies.

You got it wrong. It should be this:

=IF(F4=F5,"",SUM(G$3:G4)-SUM(I$3:I3))

AliGW on MS365 Insider (Windows) 64 bit

	F	G	H	I
3	Date	Amount		Total
4	02-01-2022	$ 202.00
5	02-01-2022	$ 200.00
6	02-01-2022	$ 456.00
7	02-01-2022	$ 356.00
8	02-01-2022	$ 345.00
9	02-01-2022	$ 867.00		$ 2,426.00
10	03-01-2022	$ 454.00
11	03-01-2022	$ 345.00
12	03-01-2022	$ 444.00
13	03-01-2022	$ 346.00		$ 1,589.00
14	04-01-2022	$ 34.00
15	04-01-2022	$ 267.00		$ 301.00
16	05-01-2022	$ 367.00
17	05-01-2022	$ 43.00
18	05-01-2022	$ 65.00
19	05-01-2022	$ 774.00		$ 1,249.00

Sheet: Sheet1

	I
4	=IF(F4=F5,"",SUM(G$3:G4)-SUM(I$3:I3))

Sheet: Sheet1

Still not one 'please' or 'thank you' from you, so that's it from me now. I have given of my time freely to help you: the least you could have done was to be courteous in your responses.

Good luck!

Sorry about my tone of response English is not my first language I will try to maintain courtesies in my reply" I am deeply regrate inconvenience caused by me" next time i will maintain courtesies in my reply Mam.

I get that - I said as much - however, 'please' and 'thank you' are some of the very first things we learn in any language. I have no doubt that you know both, so use them in future.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.