SUMIF or SUMPRODUCT?
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
D2:D1000 can't equal both "Admin" and "Tech".
|