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

Excel Sum numbers in cells that also contain text 34
Sum number range ignoring numbers formatted as text 0
Excel How to add numbers in same cell? 2
Using old Word Document (2000,2003) with Word 2007 4
Table of Content- The text overruns page numbers 2
Sum Above table with merged cells in Word 2003 2
SUMIF with criteria "<>" & "=" 4
Forms - Controls to Calculate Totals WITHOUT Using Legacy Controls 6

Top