SUM ABOVE Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tex Shalter - 27 Sep 2006 22:15 GMT

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 to this Message

Suzanne S. Barnhill - 28 Sep 2006 00:25 GMT

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

Signature

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.

> 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
[quoted text clipped - 3 lines]
>
> Thanks anyone

Reply to this Message