Sum numbers in a table word 2007

R

Rich

Columun of numbers in a table, unfortunately some of the cells have numbers
and text. Is there a way Word 2007 will preform the =SUM(ABOVE) function with
text in some cells?
 
S

Suzanne S. Barnhill

=SUM(ABOVE) never works (in any version) when some of the cells are blank or
contain nonnumeric data. But you can still use the SUM formula with specific
cell references defining a range.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Delete all data after a symbol in a field 0
Template with fields and premade texts.. 0
Setting column width in a table with a macro is not working 0
Removing Line Numbers 4
Paste to excel from word - auto format problem 1
How can the font and size of (all) citation numbers be altered? 1
How to count the numbers in a Word document? 0

Top