There are many warnings on these newsgroups not to merge cells.

Pete

On Nov 16, 8:31 pm, Wes at CCC
wrote:
It occurs when merging cells. If there are values in the various cells being
merged Excel (2002 with SP3) does not completely clear the values out of the
cells. There some residual values are included in sums and counts.

I have this on several examples. But, sometimes I cannot reproduce the error.



"Bernard Liengme" wrote:
Try to give a simple example.
best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
Microsoft Excel MVP
remove CAPS in email address

"Wes at CCC" wrote in message
...
I use Excel to do Sudoku puzzles. In the process of doing this I have
produced an Excel spreadsheet that calculates incorrectly. I cannot post
the
file here but I will email it if anyone is interested.- Hide quoted text -

- Show quoted text -