Can anyone tell me how to make the follwing formula sum "Apples" and "Pears"?
=SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)
It would be much appreciated!
Can anyone tell me how to make the follwing formula sum "Apples" and "Pears"?
=SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)
It would be much appreciated!
SUMPRODUCT((Cost!$D$3:$D$126="Apples")*Cost!$P$3:$AG$126)+SUMPRODUCT((Cost!$D$3:$D$126="Pears")*Cost!$P$3:$AG$126)