Try this in column O, adjusting ranges as necessary.
=sumproduct(($A$1:$A$100=K1)*($B$1:$B$100=M1)*($C$ 1:$C$100))
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=497867