Sean,

I formatted the 3 columns and the total column to Number with 2 decimals. I
moved the cursor on one of the sum cells where the "!" is, it said "Value
used in the formula is of the wrong data type". I setup the formula in the
Sum cell as "+A2+A3+A4". Let me know if you have any questions or
suggestions. Thanks.

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