=SUMPRODUCT(--(A1:A5="east"),--(B1:B5="type A"),C1:C5)

OR

=SUMPRODUCT(--(A1:A5=E1),--(B1:B5=F1),C1:C5)

...where E1 contains your first criteria, and F1 contains your second.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=274667