=42-SUMPRODUCT((LEFT(Servers!B2:B2000,5)="DL360")+2*(S ervers!B2:B2000="DL380")+4*(Servers!B2:B2000="DL58 0")+2*(Servers!B2:B2000="ML370"),--(Servers!C2:C2000="LCCCR30"))
Dan Wrote:
How can I rewrite the following (this does currently work):
=42-(1*SUM((Servers!B2:B2000="DL360")*(Servers!C2:C200 0="LCCCR30")))
so that the value DL360 will also be representative of the fact that
Servers!B2:B2000 also contains similar values DL360G1, DL360G2, and
DL360G3,
without creating a monstrous formula that would end up looking like
this:
=42-SUM(1*SUM((Servers!B2:B2000="DL360")*(Servers!C2:C 2000="LCCCR30")),2*SUM
((Servers!B2:B2000="DL380")*(Servers!C2:C2000="LCC CR30")),4*SUM((Servers!B2:
B2000="DL580")*(Servers!C2:C2000="LCCCR30")),2*SUM ((Servers!B2:B2000="ML370"
)*(Servers!C2:C2000="LCCCR30")))
This would not be so bad, except for the fact that I also have several
other
models that are in the Servers!B2:B2000 column, and therefore this
would get
so big that it would be too big for Excel to execute.
Please help, thanks!!
--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile:
http://www.excelforum.com/member.php...fo&userid=4165
View this thread:
http://www.excelforum.com/showthread...hreadid=275986