Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-02-2015, 04:36 AM
reneonardo reneonardo is offline Autosum in Word Windows 8 Autosum in Word Office 2010 64bit
Novice
Autosum in Word
 
Join Date: Feb 2015
Location: Norway
Posts: 3
reneonardo is on a distinguished road
Default Autosum in Word

Hi, sorry for my newbie question, but is it possible to autosum in word when some of the fields sometimes may be text and not numbers?



For examples:
---------------------------------
Apples: 10
Bananas: 4
Orange: coming soon
Kiwi: 6

Total: 20 (autosum)
---------------------------------

I would prefer if it was not in Table, but if it must, it could.
Reply With Quote
  #2  
Old 02-02-2015, 04:58 AM
gmayor's Avatar
gmayor gmayor is offline Autosum in Word Windows 7 64bit Autosum in Word Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Insert the following field in the total cell:

{ =B1+B2+B3+B4 }

Note the field will not auto-update
if you change a value.
The field will have to be in the table to work, but there is nothing to stop you formatting the table without borders so it appears that it is not in the table.
If you want it out of the table then you would need to bookmark the cells and total the bookmark values.
__________________
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
  #3  
Old 02-02-2015, 06:06 AM
reneonardo reneonardo is offline Autosum in Word Windows 8 Autosum in Word Office 2010 64bit
Novice
Autosum in Word
 
Join Date: Feb 2015
Location: Norway
Posts: 3
reneonardo is on a distinguished road
Default

Thanx a lot!
That helped me alot. I had just used "above" instead of B1+B2...
And nice tip about auoupdate not live. Look like I have to right click and the "update field"

So im guessing there is no way to active a Live Autosum in Word?
Reply With Quote
  #4  
Old 02-02-2015, 06:34 AM
gmayor's Avatar
gmayor gmayor is offline Autosum in Word Windows 7 64bit Autosum in Word Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,103
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You could perhaps make the table in Excel and link it to Word

or add the example code from http://www.gmayor.com/installing_macro.htm to a button on the QAT (Quick Access Toolbar) or ribbon and click it when you want an update.
__________________
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
  #5  
Old 02-02-2015, 07:32 AM
reneonardo reneonardo is offline Autosum in Word Windows 8 Autosum in Word Office 2010 64bit
Novice
Autosum in Word
 
Join Date: Feb 2015
Location: Norway
Posts: 3
reneonardo is on a distinguished road
Default

Really appriciate it! Thanx alot!
Reply With Quote
Reply

Tags
autosum, text fields



Similar Threads
Thread Thread Starter Forum Replies Last Post
Autosum in Word How to Autosum highlighted values in a table like in Excel The_Nster Word Tables 1 01-13-2015 01:27 PM
Autosum in Word Autosum pastes formula and not answer London_msforum Word 3 08-02-2013 05:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 AM.


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