| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ISNUMBER & SEARCH problem
Got a sheet with formula
=SUMPRODUCT(--(ISNUMBER(SEARCH("yes",raw_data!$D$2:$D$8002))*(--(ISNUMBER(SEARCH(D2,raw_data!$U$2:$U$8002)))))) - basically it is searching another sheet for number of 'yes' responses from group of people in D2 (i.e. sales). Works fine but is counting "sales & marketing", "web sales" etc - I only want it to count lines that have a "yes" and "sales" only - hope that makes sense. Any help gratefully rec'd. -- DJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine: ISNUMBER(SEARCH( and EXACT( ? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT + ISNUMBER(SEARCH) + Empty Cells | Excel Discussion (Misc queries) | |||
| Limit to nested IF(ISNUMBER(SEARCH)) functions? | Excel Worksheet Functions | |||
| problem with =isnumber(match(right(... | Excel Worksheet Functions | |||
| Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Threaded Mode
