Planning, Scheduling & Programming Discussion Member for 15 years Member for 15 years Submitted by akherief on Thu, 2013-01-31 13:33 Permalink SUMPRODUCT((Cost!$D$3:$D$126= SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)+SUMPRODUCT((Cost!$D$3:$D$126="Pears")*Cost!$P$3:$AG$126) Log in or register to post comments
Member for 15 years Member for 15 years Submitted by akherief on Thu, 2013-01-31 13:33 Permalink SUMPRODUCT((Cost!$D$3:$D$126= SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)+SUMPRODUCT((Cost!$D$3:$D$126="Pears")*Cost!$P$3:$AG$126)
Member for
15 yearsSUMPRODUCT((Cost!$D$3:$D$126=
SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)+SUMPRODUCT((Cost!$D$3:$D$126="Pears")*Cost!$P$3:$AG$126)