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?