Hi, below is formula to place sum of above cell in every cell in a excel sheet. sum formula with-out selecting range in excel in every cell.
No need to require selection for sum.
=SUM(INDIRECT(ADDRESS(1, COLUMN()) & “:” & ADDRESS((ROW()-1), COLUMN())))