Sum of all cells above

Tag(s):

=SUM(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN())))

https://superuser.com/a/661848