Thanks! That helps me out tremendously.

"Daniel.M" wrote in message
...
Hi,

Now, how would this be structured as one concise formula? I think I
realize


=42-SUMPRODUCT({1,2,4,2}*(LEFT(Servers!B2:B2000,5)={"D L360","DL380","DL580",
"ML3
70"})
*(Servers!C2:C2000="LCCCR30"))

Regards,