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!
Links:
[1] http://www.planningplanet.com/forums/planning-scheduling-programming-discussion