On Wed, Sep 16, 2015 at 11:27:12PM +0200, Floris wrote: > What is your decimal separator? > > Go to Tools --> Options --> language Settings --> Languages > > Because when I replace the dots, with a comma the formula > =SUM(N1:N8) works
Interestingly, on my system the items in those cells are not numbers at all. They're labels (text) that therefore add up to zero. -- Carl Fink nitpick...@nitpicking.com Read my blog at blog.nitpicking.com. Reviews! Observations! Stupid mistakes you can correct!
