Thread: excel 2013 summary line totals float
View Single Post
 
Old 03-02-2017, 10:15 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
(1) Convert your range to an Excel Table, right click somewhere in the table and press Table, then press Totals Row.
(2) Use a formula like: =SUM($A$1:UpOne) where UpOne is a named formula entered in A2 and the formula should be: =A1 (without any dollar signs)
(3) Use a formula like: =SUM($A$1:INDEX(A:A, ROW()-1)) or
(4) File, Options, Advanced, tick Extend data range formats and formulas.
Reply With Quote