Hi Mike
If I set the Format of the cells to be 'Number" with 2 decimals values a
3.22 / 3.61 / 2.74 / 2.78 / 1.00 / 0.79 Sums = 14.14

If I set the Format to Custom and use _(*#,##0);(#,##0);(*"-"?? etc
values become:

3 / 4 / 3 / 3 / 1 / 1 ( I would like value to reflect 15)
If i use =Sum(INT(D3:J3)) i get a value of 11????
if I use = Sum(ABS(D3:J3)) i get the value of 14.4
If I use =Sum(VALUE(D3:J3)) I get a value of 14

But I cannot seem to get a value of 15. thanks


"please_post_to_groups" wrote:

Greetings All

sorry if this the second post the first one never made it through...gremlins in the system

Im getting a strange #ref error message in excel and Im not sure
why. Everything works great up to cell and row. but when I get past
that the #ref error pops up. Is this a limit to excel 2003? Anyone
have any workarounds or recommendations?

The code I start to get the error at is =INDEX($D$3:$D$62,2*ROWS
($1:31)+COLUMNS($D:D)-2)

An image can be found at http://test.onewithall.net/problem/excel_problem.jpg
or the Excel file can be found at is http://test.onewithall.net/problem/excel_problem.xls

Tia sal2