SUM formula in Excel2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I cannot get the columns to add and give me a total below them.
I get sum= 0.

I tried autosum function, and manually typed formula. just does not make
sense.
 
The data is not text is it?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Any chance that the data in the columns is not in a numerical format? Does
something like this resolve the problem:

=SUM(VALUE(A1:A100))

Where the formula is entered using Ctrl-Shift-Enter, not just the Enter key?
(Of course, change the A1:A100 range to your actual range of cells to be
summed.)
 
Did not work...Shows #VALUE#.

All it is is a spreadsheet for my workers hours. the preceding column is a
product of their hours worked times their wage. The column in question is
just adding all of the total wages. Very wierd this is not working. I dont
have any circular references, it just comes up with 0's.
 
Which proves your numbers are text, my guess is that you have invisible html
characters. If you make sure you don't have formatted for any alignments
then if it is text it should be left aligned by default, if it is a number
it should be right aligned
 
Just to add...

The numbers can still be TEXT even if the format says general or number. If
the numbers were entered or imported as TEXT simply changing a cells format
will not convert the TEXT numbers to NUMERIC numbers. They won't be
converted until the cell is edited.

One way to do this to all the cells at once is to copy an empty cell that
has never been used. Its default format is still GENERAL. Then select the
range of numbers to convert and do a Paste Special>Add>OK.

In effect, what you're doing is copying the GENERAL format from the empty
cell and editing the cells at the same time by using the Add operation.
You're adding 0 so there is no change in the cell value.

Biff
 
Back
Top