I've just discovered that with a specific situation, the =SUM(ABOVE)
formula will misbehave... At least it's misbehaving as far as I can tell...
Produce a 3x3 table, with the bottom-left two cells merged and fill like so:
Believe it or not, that equation will come out to 5
... 2 + 3
.
I've confirmed this by changing those values, and the issue appears to be exacerbated by more merged columns.
The following will all result in the correct 3
being produced:
- Remove the merge
- Remove the top row
- Insert a row directly above - note: with or without a number in it
- Insert a number into the top row
- Insert an empty column between the
2
and3
- note: without a number in it
Am I missing something, or do we have to be very careful when using merged cells and formulae?
Is there something more correct than ABOVE
to use here?
I'm using Word 2013.
My solution for now is to simply avoid merged cells, and keep the column counts the same throughout - even if they aren't aligned: