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