Ok, it's wrong, in the
=SUMPRODUCT(--(Sheet1!B1:B100="BT2,DB,CN,CN3,BT1"),--( section, I need
it to be any of the variables, this isn't counting them unless it
satisfies all of them. I want it to be if it's DB or CN or... etc.
How can I acheive this?

God, I didn't realise after 2 years of no excel use it would all be
gone :s.


--
alexy
------------------------------------------------------------------------
alexy's Profile: http://www.excelforum.com/member.php...o&userid=25905
View this thread: http://www.excelforum.com/showthread...hreadid=392835