| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumProduct (gimme a 1 if this is true, gimme the value) what i
"Biff" wrote :
=SUMPRODUCT(--(ISNUMBER(MATCH(Data!$C$2:$C$1500,{"98366","98367" },0))),--Dat a!$AB$2:$AB$1500)/--$B$417 It's a good refinement, Biff. But going by the same tack that there could be a mixture of real/text numbers within col C, think a slight adjustment would be: =SUMPRODUCT(--(ISNUMBER(MATCH(TEXT(Data!$C$2:$C$1500,"00000"),{" 98366","9836 7"},0))),--Data!$AB$2:$AB$1500)/--$B$417 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
| If condition is true return sumproduct of two arrays | Excel Worksheet Functions | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Hybrid Mode
