Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word Tables

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-28-2017, 02:03 AM
evie073 evie073 is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2017
Posts: 1
evie073 is on a distinguished road
Lightbulb Formula not working in Word 2016

Hi there everyone,

I have a super frustrating issue, I am trying to use the auto sum (formula icon) key to add values in a table in word 2016. I have added all the figures, and thought it was pretty simple. as in click Formula icon check it says =SUM(ABOVE) then click okay, but nope, it just pastes the formula into the cell not the answer. Please if anyone knows what I'm doing wrong please advise.



Many thanks in advance
Reply With Quote
  #2  
Old 11-28-2017, 04:03 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Word's formulae need to be inserted as field codes. For example, select your '=SUM(ABOVE)' and press CtrlF9, so you get {=SUM(ABOVE)}, then press F9. To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MathType not working with Word 2016 update Stephen G. Word 8 04-17-2017 03:48 PM
Section breaks not working in Word 2016 inmercyrejoice Word 33 03-02-2017 05:00 AM
Word 2016, autoformating existing text not always working tammons Word 7 08-23-2016 12:47 AM
VBA Code for Grammar Check Not Working in Word 2016 PSSMargaret Word VBA 2 06-11-2016 10:53 PM
WORD 2016 drag and drop not working fantomasanders Word 0 09-26-2015 06:16 AM


All times are GMT -7. The time now is 02:08 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft