I understand what you did, but it wont work for some reason.. I uses those
from another sheet like called TRACKING LIST which i know how and i used the
number from another sheet where the function have =E2-(SUM(G2:DC2)) in one
cell.

What I did, but it wont work.
=SUMPRODUCT(('TRACKING LIST'!C1:C1000="SB")*('TRACKING
LIST'!D1:D1000=1);('TRACKING LIST'!E1:E1000))

It gave me an error...

Sorry for bugging you..