Ooops!
Disregard my previous reply.
=Main!G3*SUMIF(I21,"T",H21),Main!C3*SUMIF(I21,"M", B21),MainC4*SUMIF(I21,"A",B21)
Not really sure what you're wanting to do with this. Maybe:
=Main!G3*SUMIF(I21,"T",H21)+Main!C3*SUMIF(I21,"M", B21)+MainC4*SUMIF(I21,"A",B21)
Or:
=SUM(Main!G3*(I21="T")*H21,Main!C3*(I21="M")*B21,M ain!C4*(I21="A")*B21)
Biff
"Biff" wrote in message
...
Hi!
One way:
=Main!G3*IF(OR(I21={"M","A"}),B21,IF(I21="T",H21,0 ))
Biff
"Xenos" wrote in
message ...
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