hi!

try this!

=SUMPRODUCT(--(A1:A9=E1)*(B1:B9=F1)*(C1:C9))

assuming that your data in A1:C9
and your conditional value of COL A & COL B in E1 & F1 respectively!!!

-via13

--
via13
-----------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...fo&userid=2672
View this thread: http://www.excelforum.com/showthread.php?threadid=52954