A.3.05 B.3.1 C.3 D.3.00
A.=SUM(C2:F2) B.=SUM(C3:F3) C.SUM(C2:F2) D.SUM(C3:F3)
A.Sheet1!A2 B.Book2!Sheet1(A2) C.BookSheet1A2 D.[Book2]sheet1!A2