Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up a formula in a Word table that adds cell values?
In versions of Word before 2007, a simple formula could be entered in a cell
that would sum the values to the left or above that cell. This function seems to have disappeared? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up a formula in a Word table that adds cell values?
You can still do it but
a. the standard field insertion dialog box is now in the Insert tab, Text group, Quick parts dropdown, Field... (you can put the Insert a Field function in the QAT if you want) b. as long as you know what the formula needs to look like, e.g. SUM(ABOVE) or whatever, you can always insert the field manually by using ctrl-F9 to insert a pair of the special field braces and type the rest in between,. -- Peter Jamieson http://tips.pjmsn.me.uk "Adrian Sark" wrote in message ... In versions of Word before 2007, a simple formula could be entered in a cell that would sum the values to the left or above that cell. This function seems to have disappeared? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How do I set up a formula in a Word table that adds cell values?
The function remains. With the cursor in the table cell where you want the
formula, click the Layout tab and the last command on the ribbon is Formula. If there are numbers in the column or row the appropriate sum command will be inserted into the dialog. Otherwise you can add the formula =SUM(ABOVE) or =SUM(LEFT) or whatever. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Adrian Sark wrote: In versions of Word before 2007, a simple formula could be entered in a cell that would sum the values to the left or above that cell. This function seems to have disappeared? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I put a simple formula in a cell in a Word table? | Tables | |||
Formula to multiply values from drop down boxes in table. | Tables | |||
Hard return within a Word table cell adds a mystery row | Microsoft Word Help | |||
Formula to Sum values in word table | Mailmerge | |||
Word 2003 Table cell formula | Tables |