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!!