Excel function

  la la 08:56 07 Dec 2008
Locked

I have found that my "Sum" function in Excel is no longer working - everything else okay. Any ideas how to restore it.

  VoG II 09:17 07 Dec 2008

In what way is it not working?

  la la 09:22 07 Dec 2008

it isn't adding up columns of figures

  VoG II 09:24 07 Dec 2008

Are you sure the figures you are trying to sum are not numbers stored as text?

  la la 09:35 07 Dec 2008

no - has been working okay up until now

  VoG II 09:36 07 Dec 2008

Try in a new workbook - type in some numbers and try to sum them. Does it work?

  Pineman100 09:38 07 Dec 2008

What are you getting in the Sum cell?

  la la 09:41 07 Dec 2008

Thanks for advice - will try later have to go out now.

  Pineman100 09:47 07 Dec 2008

Sorry - I was typing as VoG™ posted. His advice will be definitive anyway.

  VoG II 09:48 07 Dec 2008

A couple of other things to try.

Say your sum function is =SUM(A1:A10) then what does =COUNT(A1:A10) give? If it gives 0 the figures are not stored as numbers.

If that is the case select the figures, Data > Text to Columns and click Finish.

  Pineman100 09:55 08 Dec 2008

This is probably a silly thought, but the reason for my question above was to discover whether you're just getting hashes (######) in the Sum cell.

If so, then the cell is too narrow for the figure it needs to display. Just increase its width manually, or double click on the column divider in the header row at the end of the cell.

Sorry if that point is insultingly basic!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

8 brilliant character artists speaking at Pictoplasma 2018

iMac Pro release date, UK price & specs

Football : comment regarder la Ligue 1 en direct ?