Apache OpenOffice Community Forum

I have a row and a column with totals The totals should match, but mine don't. Is there any function or formula that I can use to find the error that causes the mismatch?

Edit: Changed subject, was Error Finding  Make your post understandable by others  -- MrProgrammer, forum moderator

Check that all your values are numbers - some may be text.

The easiest way to do Rory's suggestion is to turn on Value Highlighting (View -> Value Highlighting or Ctrl+F8)
This is an on/off switch. When on your text entries will look black, your numbers will look blue and your formula results will look green
The actual colours may appear different from the above, but will be close.