I am not very knowledgeable in excel. I have data that was imported into
excel as text. each column is characters. Each column represents time
duration. All charecters are zero except the last one or two in each column.
I have tried different formats to try to add the totals but keep getting a
zero for the total. What am I doing wrong?

=sum() will ignore text. So I would think if you imported the data as real
numbers, then your formula would work ok.



ARS_MEL wrote:

I am not very knowledgeable in excel. I have data that was imported into
excel as text. each column is characters. Each column represents time
duration. All charecters are zero except the last one or two in each column.
I have tried different formats to try to add the totals but keep getting a
zero for the total. What am I doing wrong?

--

Dave Peterson

Hi,

If your data is a column something like

0001
0002
0001
0023
0014

then try =SUM(VALUE(A1:A5)) entered as an array formula with
Control-Shift-Enter

Dave

url:http://www.ureader.com/msg/104234935.aspx