Hello,

In this case a simple addition is ok but generally, if the OR criteria
can both be TRUE, wrap them with SIGN:

=SUMPRODUCT(--(B2:B1000="'Computer
Sales"),SIGN((D2:D1000="Admin")+(D2:D1000="Tech")) ,E2:E1000)

Regards,
Bernd