sum values in sumrange if col1 = "x" OR"y" OR "z" AND col2 = "p" OR "q"

Something like this:
=SUMPRODUCT(((B2:B4="x")+(B2:B4="y")+(B2:B4="z"))* ((C2:C4="p")+(C2:C4="q")),A2:A4)

Do press the "Yes" buttons (like the one below) for responses which answer
your questions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---