Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-11-2021, 10:27 AM
frozen_sun frozen_sun is offline autosum values of a column Windows 10 autosum values of a column Office 2019
Novice
autosum values of a column
 
Join Date: Dec 2021
Posts: 1
frozen_sun is on a distinguished road
Default autosum values of a column


Hi.
A chief of mine created a table 4x4 and in 2 columns in last row (row number 4),
I need to autosum values above (from 3 above rows)...I need to create the same formula (autosum) on second row.
How do I do that?
When I type autosum (above) it does nothing.
Because I will be changing numbers each day,I need in last row to autosum each time based on those values.
Reply With Quote
  #2  
Old 12-15-2021, 09:47 PM
gmayor's Avatar
gmayor gmayor is offline autosum values of a column Windows 10 autosum values of a column Office 2019
Expert
 
Join Date: Aug 2014
Posts: 3,711
gmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to beholdgmayor is a splendid one to behold
Default

Word tables do not recalculate automatically. You can insert a field: { =SUM(ABOVE) } to sum the values, but you would have to update it following changes. You can do that easily enough with a macro e.g.
Code:
Sub UpdateAllFields()
Dim oStory As Range
    For Each oStory In ActiveDocument.StoryRanges
        oStory.Fields.Update
        If oStory.StoryType <> wdMainTextStory Then
            While Not (oStory.NextStoryRange Is Nothing)
                Set oStory = oStory.NextStoryRange
                oStory.Fields.Update
            Wend
        End If
    Next oStory
lbl_Exit:
    Set oStory = Nothing
    Exit Sub
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-Entering Values into a Column in a Table based on Value in Adjacent Column nytvsh Excel 2 12-06-2021 12:33 AM
corresponding row values for max value in a column marconexcel Excel 2 11-23-2021 09:26 AM
Formula to check combinations of values in one column to find match from another column kong1802 Excel 1 06-15-2018 05:26 AM
Insert rows when column A data changes then shade and autosum blanks in columns E to I kgoosen Excel Programming 0 08-30-2017 04:45 AM
autosum values of a column How to Autosum highlighted values in a table like in Excel The_Nster Word Tables 1 01-13-2015 01:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft