Google Sheets

Hotkeys

Select row

Shift + Space

Delete selected row/column

Command + Option + -

Functions

Add sum cell below column

=SUM(INDIRECT("X2:X" & row() - 1))
OR
=SUM(INDIRECT(char(64+column()) & ":" & char(64+column()) & row() + 1))