-
Notifications
You must be signed in to change notification settings - Fork 0
Google Sheets
alex [dot] kramer [at] g_m_a_i_l [dot] com edited this page Aug 8, 2020
·
5 revisions
Select row
Shift + Space
Delete selected row/column
Command + Option + -
Add sum cell below column
=SUM(INDIRECT("X2:X" & row() - 1))
OR
=SUM(INDIRECT(char(64+column()) & ":" & char(64 + column()) & row() + 1))
Divide previous cell by another cell
=ROUND(INDIRECT(char(64 + column() - 1) & row()) / X3, 2)