SUM ABOVE Question "Tex Shalter" <anon.x[ at ]anon.invalid> 27.09.2006 21:15:37 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

Re: SUM ABOVE Question "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 27.09.2006 23:25:40 Not with Sum(Above), but you can use Sum with specific cell addresses. See http://word.mvps.org/FAQs/AppErrors/SumAboveIncorrect.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" <anon.x[ at ]anon.invalid> wrote in message news:ZRBSg.237644$5i3.11465[ at ]bgtnsc04-news.ops.worldnet.att.net... [Quoted Text] > 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 > >