#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
|
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 |
How to Autosum highlighted values in a table like in Excel | The_Nster | Word Tables | 1 | 01-13-2015 01:27 PM |