One way:

=SUMPRODUCT((A2:A15="A")*(B2:B15={"X","Y","Z"})*(C2:C15))


Regards