Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sumproduct ??
Ive used this formula successfully
=SUMPRODUCT(--(I1:I18="GTB1"),--(J1:J18=0)) What I would like to do is look for GTB1 and LOB1 in column I I tried =SUMPRODUCT(--(I1:I18={"GTB1","LOB1"}),--(J1:J18=0)) But it didnt work, it returned #value! Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |