> Using libreoffice vLibreOffice 3.3.0 OOO330m19 (Build:5) tag
> libreoffice-220.127.116.11, on LinuxMint Debian Edition.
> Created two columns of figures
> (a) Col B consists of 34 rows of figures. Rows B9,
> B16, B20, B29, B34 are total categories, shown as figures not formula.
> (b) Col C has figures in rows C8, C13, C14, C15, C19, C23.
> (c) adding the figures in the rows given in (a) above, i.e. =B9+
> B16+B20+B29+B34 returns the error #VALUE!. I tried enclosing in brackets
> with the same result.
> (d) In Col C. Highlighting rows C5:C34) and then hitting SUM only returns
> the value of C23. Adding C8+C13+C14+C15+C19+C23 returns the error message
> Has anyone else come across this, please? It appears to be a bug.
> Incidentally, I do not have the same problem if I use OpenOffice Calc. All
> works as expected.
I bet your are trying to sum up text values. Hit Ctrl+F8 which
highlights numbers in blue font.