I thought you are searching for the whole string: "BT2,DB,CN,CN3,BT1".
But...
I believe there exists an easier way out, but for the moment here's an
alternative:
=SUMPRODUCT(--(Sheet1!B1:B100="BT2"),--(Sheet1!D1:D100=6),--(Sheet1!E1:E100=25))+SUMPRODUCT(--(Sheet1!B1:B100="DB"),--(Sheet1!D1:D100=6),--(Sheet1!E1:E100=25))
and so on.
Mangesh
--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread:
http://www.excelforum.com/showthread...hreadid=392835