Hi D,

Perhaps the iignored values are formatted as text or have an apostophe as a
prefix character?


---
Regards,
Norman



"D" wrote in message
...
I have inherited a complex spreadsheet and have encountered the following
problem:

I am trying to add up a row and although the formula is correct, the
values
are ignored. This happens if I use Autosum or =A1+B1.

Any ideas?