Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Tex Shalter Tex Shalter is offline
external usenet poster
 
Posts: 12
Default SUM ABOVE Question

While adding up a column of table cells, the formula only adds them all up
if each cell has a number in it. I have resorted to placing a "0" instead
of leaving some blank.

Is there a better way to get SUM-Above to work while some cells are empty ?

Thanks anyone


  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default SUM ABOVE Question

Not with Sum(Above), but you can use Sum with specific cell addresses. See
http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Tex Shalter" wrote in message
...
While adding up a column of table cells, the formula only adds them all up
if each cell has a number in it. I have resorted to placing a "0" instead
of leaving some blank.

Is there a better way to get SUM-Above to work while some cells are empty

?

Thanks anyone



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
what key is question mark on Brazilian language keyboard? recife Microsoft Word Help 5 April 27th 23 02:48 PM
Be nice if your suggested answers fit the question. Harvey Eastman Microsoft Word Help 3 April 20th 06 02:59 PM
Exam question wrong about Word? Opinions, please! Jamie Furlong New Users 6 April 18th 06 11:56 AM
How do I find a question I posted earlier??? Jim Microsoft Word Help 3 August 16th 05 08:34 PM
Newbie document question please Dudley Henriques New Users 4 January 9th 05 08:38 PM


All times are GMT +1. The time now is 08:37 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"