Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF or SUMPRODUCT?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif or Sumproduct? | Excel Discussion (Misc queries) | |||
Sumif/Sumproduct Help | Excel Worksheet Functions | |||
HELP !!! SUMIF or SUMPRODUCT | Excel Discussion (Misc queries) | |||
HELP Sumif or Sumproduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT or SUMIF or ... | Excel Worksheet Functions |