[Tex Shalter]

I thought I should share this with the group:

If you create a cell with the formula "sum-above" but all the cells above it
are blank, then the formula field updates not as "0", but as the cell
adjacent (left) to it. At least that's how it works in one of my tables.
Much frustration to figure this one out.

Does anyone know of a published list of similar table formula quirks like
this ?

[Jay Freedman]

See http://www.word.mvps.org/FAQs/AppErr...eIncorrect.htm and
http://www.word.mvps.org/FAQs/TblsFl...otalColumn.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Tex Shalter wrote:
I thought I should share this with the group:

If you create a cell with the formula "sum-above" but all the cells
above it are blank, then the formula field updates not as "0", but as
the cell adjacent (left) to it. At least that's how it works in one
of my tables. Much frustration to figure this one out.

Does anyone know of a published list of similar table formula quirks
like this ?

[Tex Shalter]

Thanks to all you volunteers especially you Jay,


"Jay Freedman" wrote in message
...
See http://www.word.mvps.org/FAQs/AppErr...eIncorrect.htm and
http://www.word.mvps.org/FAQs/TblsFl...otalColumn.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

Tex Shalter wrote:
I thought I should share this with the group:

If you create a cell with the formula "sum-above" but all the cells
above it are blank, then the formula field updates not as "0", but as
the cell adjacent (left) to it. At least that's how it works in one
of my tables. Much frustration to figure this one out.

Does anyone know of a published list of similar table formula quirks
like this ?