I am trying to build a formula that will do different calculations based
on the letter in I21. Can someone lend some advice on how to right
this.



=Main!G3*SUMIF(I21,"T",H21),Main!C3*SUMIF(I21,"M", B21),MainC4*SUMIF(I21,"A",B21)


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