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.

"andy62" wrote:

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.)

"TTHuff" wrote:

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.