I would go back to the "sending" cells and verify that they're really
numbers--not just text that look like numbers.

You could use a formula like:
=isnumber(c4)
to check any single cell.

If you see False, then you can reformat the cell as General (or anything but
Text) and then reenter the value or formula (Hit F2, then enter).

americasrecycler wrote:

On sheet2 of my workbook:

A B C D E F G
1
2
3
4

A1=IF('Good Units'!$B$41=C3,'Sheet1'!$D$41,C4) similar formulas for
B1,C1,D1,E1,F1(to B4,C4,D4,F4)

Now on A4 (to F4), I could be able to get the result using = sum(A1:A4) ,
but on G1(to G4), I only got "0" from =sum(A1:F1)

In another word, I only get the sum for each column, but I coudn't get the
sum for the accross the rows.

Thanks in advance

--

Dave Peterson