The following formula is returning a €˜0 outcome:
=SUMPRODUCT(--('TB SAICMB'!B2:B1000="'Computer Sales"),--('TB SAICMB'!D2:D1000="Admin"),--('TB SAICMB'!D2:D1000="Tech"),'TB SAICMB'!E2:E1000)

when using SUMIF I get the desired result but is missing one criteria range ('TB SAICMB'!B2:B1000="'Computer Sales"):
=SUMIF('TB SAICMB'!B2:B1000,C5,'TB SAICMB'!E2:E1000)

Can I adapt the SUMIF formula to include this range or am I going wring in
my SUMPRODUCT layout?

Regards

EricB