A.=$F2 B.=$A1 C.=$A2 D.=$F1
A.=SUM($B$1:$D$3) B.=SUM($B$1:$C$3) C.=SUM(#REF!) D.#NAME?
A.A1+B1 B.A1*B2 C.=A1*(B1+B2) D.=A1+SUM(A2B1)