Hi,

There are 2 things. You have an apostrophe before the C in Computer sales,
is that a typo. More importantly you are looking for "Admin" and "Tech" in
column D and it won't be both of those so every row will evaluate as zero.
What are you actually looking for in column D?

Mike

"EricB" wrote:

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