Skip to main content

Sum formula without selecting range in excel in every cell

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())))

Leave a Reply

Your email address will not be published. Required fields are marked *