Forum Discussion

S-C-K's avatar
S-C-K
Copper Contributor
Apr 24, 2023
Solved

AutoSum of a column is not updating when a row is added above it. Suggestions?

How can I get autosum of a column to update automatically when a new row is added above the autosum?  
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Apr 24, 2023

    S-C-K 

    Format your data as Table > Activate the Total Row for that Table > For each column where you expect a SUM, on the total row: SUBTOTAL(109, [<ColumnName>])

     

    Sample attached

Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 24, 2023

S-C-K 

Format your data as Table > Activate the Total Row for that Table > For each column where you expect a SUM, on the total row: SUBTOTAL(109, [<ColumnName>])

 

Sample attached

  • S-C-K's avatar
    S-C-K
    Copper Contributor
    Apr 24, 2023
    Thank you so much!
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 24, 2023
      You're welcome (Tables bring many other benefits...) & Thanks for providing feedback

Resources