WOW, Thanks man ... you wrote it for me.

=SUM(Main!G3*(I21="T")*H21,Main!C3*(I21="M")*B21,M ain!C4*(I21="A")*B21)

Seams to work .... Just playing with it now.


--
Xenos
------------------------------------------------------------------------
Xenos's Profile: http://www.excelforum.com/member.php...o&userid=26526
View this thread: http://www.excelforum.com/showthread...hreadid=470527