Function to add all values above the selected cell?

[khushi_g5]

Is there a way to get the sum of all of the values above the cell plus the value in the cell itself? I tried doing sum(A1:A5) and it was fine for that cell but when I applied it to the next cell, it did sum(A2:A6) when it should've been sum(A1:A6). is there a way to do that?

[#2]

@khushi_g5 

Use

=SUM(A$1:A5)

The $ makes the row number 1 absolute, i.e. it "fixes" it.