How can one cell contain *both* separate entries at the same time?

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
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