SUM ABOVE Question

[Tex Shalter]

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

 

[Suzanne S. Barnhill]

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