"Ragdyer" wrote:
... In C32 enter:
=SUMPRODUCT((Sheet1!$D$9:$D$14=A32)*(Sheet1!$J$9:$ J$14=B32)*(Sheet1!$E$9:$E$
14="A325")*Sheet1!$C$9:$C$14)
Think Ragdyer meant "SAE"
instead of "A325" for the formula in C32 <g,
viz:
In C32:
=SUMPRODUCT((Sheet1!$D$9:$D$14=A32)*(Sheet1!$J$9:$ J$14=B32)*(Sheet1!$E$9:$E$
14="SAE")*Sheet1!$C$9:$C$14)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---