How can this be done for AutoSum?

[Anderon]

Ron's Baccarat Tracker 1-9-22 294 BP.xlsx
	I
4	75
5	70
6	65
7	70
8	85
9	60
10	80
11	110
12	150
13	100
14	145
15	90
16	40
17	100
18	30
19	35
20	35
21	50
22	75
23	40
Master

Cell Formulas
Range	Formula
I4	I4	=SUM(D4:D1319)
I5:I23	I5	=SUM(D5:D320)

What I need for this in column I4 it's =SUM(D4:D1319) and when I copy it the rest of the rest of the way down that D4 then goes to D5, D6, D7 and so on...how can I keep each cell down the column to all be the same as I4 which is =SUM(D4:D1319), I need that in every cell down the column...is there an easy way of doing that by chance?

Thanks so much for the help!!

 

[RoryA]

Do you mean

=SUM(D4:D$1319)

 

[Joe4]

If you place a "$" in front of the row or column reference, it will lock it down, so it will NOT shift when you copy down the column, i.e.
D$4

 

[Anderon]

If you place a "$" in front of the row or column reference, it will lock it down, so it will NOT shift when you copy down the column, i.e.
D$4

Perfect...That did it!! Thanks so much for the help, I really appreciate it!!!

 

[Joe4]

You are welcome.

Note: When you are marking a reply as the solution, you want to pick the reply that contains the solution (not your post acknowledging that another post was the solution).
You would only mark your own post as the solution if you solved your own problem, and posted the solution yourself.
I have updated it for you.