"Serge" wrote:
.. It work well until I copied the formula
to empty cell to give me a "#NA" for
answer. can the formula be modified?

I'm not sure how you got that #N/A error, but you could
try these 2 slight variations* to what I suggested earlier
(note that my suggestion is a little different from Ragdyer's)
*with a simple error trap to check on col A & B having inputs

In C20, copied to C22:
=IF(OR(A20="",B20=""),"",SUMPRODUCT((Sheet1!$D$9:$ D$14=A20)*(Sheet1!$J$9:$J$
14=B20)*(Sheet1!$E$9:$E$14="A325"),Sheet1!$C$9:$C$ 14))

In C32, copied to C34:
=IF(OR(A32="",B32=""),"",SUMPRODUCT((Sheet1!$D$9:$ D$14=A32)*(Sheet1!$J$9:$J$
14=B32)*(Sheet1!$E$9:$E$14="SAE"),Sheet1!$C$9:$C$1 4))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---