| 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. |
|
#2
|
|||
|
|||
|
Try
=SUMPRODUCT(--(I1:I18={"GTB1","LOB1"})*--(J1:J18=0)) "PhilGTI" wrote in message ... I've 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 didn't work, it returned #value! Thanks for your help. |
|
#3
|
|||
|
|||
|
Try...
=SUMPRODUCT((I1:I18={"GTB1","LOB1"})*(J1:J18=0)) or =SUMPRODUCT(--(ISNUMBER(MATCH(I1:I18,{"GTB1","LOB1"},0))),--(J1:J18=0)) Hope this helps! In article , "PhilGTI" wrote: 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. |
|
#4
|
|||
|
|||
|
Thanks!
"Domenic" wrote: Try... =SUMPRODUCT((I1:I18={"GTB1","LOB1"})*(J1:J18=0)) or =SUMPRODUCT(--(ISNUMBER(MATCH(I1:I18,{"GTB1","LOB1"},0))),--(J1:J18=0)) Hope this helps! In article , "PhilGTI" wrote: Iâve 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 didnât work, it returned #value! Thanks for your help. |
| Reply |
| 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 | |||
Linear Mode
