Thanks very much for your prompt response, Sean.

I selected one of the sum cells and click the = to the left of the formula
bar, I do not see anything. I used both formulas for sum cells
"=sum(A2:A4)" and "+A2+A3+A4". Do I need to format the columns in any
formats (Number, Currency, Accounting, etc.)? The columns came in as
General format. Do I need to format the Sum cells first before setting the
formulas? Below is the sample data. I need to add 675.00+923.30+933.30.
Please let me know if you have any other questions. Thanks.

675.00 923.30 933.30
675.00 826.70 770.00
925.00 826.70 860.00
750.00 910.00 893.30
575.00 920.00 826.70
350.00 910.00 750.00



"Sean Timmons" wrote in message
...
We can narrow down, perhaps.

If you select one of the sum cells and click the = to the left of the
formula bar, it will provide which portion of the sum is not being
recognized.

To be safe, it may be helpful if we could see a small sample of the data
you
are attempting to sum.

Oh, and one other thought.. when you go to sum the columns, do you have,
say, =sum(A2:A4)? What formula are you putting in the sum cells?

"Diane Walker" wrote:

Thanks very much for your prompt response, Sean. This file was imported
into Excel format using Delimited format. I tried your suggestions and
still got the same error message "#VALUE!" . Do you have any other
suggestions? Thanks.

"Sean Timmons" wrote in message
...
Sounds like maybe the values you are trying to sum may have been copied
from
elsewhere.

In another cell, type 1
Copy the 1.
Highlight your three columns
Right-Click and select Paste Special
Select Multiply
Click OK
see if it adds up now...

"Diane Walker" wrote:

We are running Excel 2003. The data was imported into Excel. We want
to
get the total of 3 columns. However, we got the error message in the
Total
cell "#VALUE!". We resize the Total cell and it still did not work.
The
3
columns were formatted as General. We reformatted to Numeric with 2
Decimals. We still got the same error message in the Total cell
"#VALUE!".
We reformatted the 3 columns to Currency, Accounting, and Custom.
The
Total cell still shows "#VALUE!". Do you have any suggestions on how
to
fix
the values in the 3 columns? Thanks.