A.=sum($B2:$E2) B.=sum($B$2:$E$2) C.==sum($B$3:$E$3) D.=sum(B$3:E$3)
A.=SUM(C3:C6) B.=SUM(C4:C7) C.=SUM(E3:E6) D.SUM(E3:E7)
A.=B3+C3 B.=C$3+D$3 C.=B$4+C$4 D.=C&4+D&4