- NEW!
by Brian I on August 17th, 2009
You can only sum numbers, so you will have to come up with a system that has only numbers in the column to be summed. For example, you could have the numbers in one column and the text in an adjacent column.
If ALL of your entries start with a single figure between 1 and 9 you could use the LEFT function to copy that figure into a different column and then sum those figures. Using something like this will strip out the single number:
=VALUE(LEFT(A1,1))
Copy that down as far as you need and you will be able to use the SUM function to add them up.
How do I change the number of characters in a line?
by Answerbag Staff on July 22nd, 2010
| 1 person likes this
Why must I learn how to jump thru the exact hoops to manipulate Microsoft products into not destroying my day's work?
by purplecows on October 31st, 2011
| 1 person likes this
How do I open a very large Microsoft Word document without enough memory?
by Answerbag Staff on June 14th, 2010
| 1 person likes this
I have microsoft office 2003. In print mode, how can you change the default settings. I try changing it and it changes back.
by stretch on August 25th, 2011
| 1 person likes this
With the release of Microsoft Office 365 and its cloud service, are they abandoning stand alone software?
by Echo141 on June 29th, 2011
| 1 person likes this
You're reading How do i sum figures in a table in micrcosoft word if there are some cells that have characters inside. e.g. 4days, 7days or some cells are all words e.g depending on availability. How to sum these figures up, because the end sum appears as zero.
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!
Comments
I should have read the category properly before I answered. My answer assumed you were using Excel, so I don't know whether it will work in Word - sorry.
by Brian I on August 17th, 2009