Hi

=SUMPRODUCT(--(A1:A6=1),--(B1:B6="Alan"),C1:C6)

the critertia can be cell references holding the criteria values.

Richard