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
A.=A8+$B$4 B.=A8+$B$5 C.=A7+$B$4 D.=A7+$B$5