| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need solution for wildcard use in array
I need to find a solution for the following formula to be used in an Excel
worksheet in Excel 2003: =SUM((('GCP Vendors'!L3:L999)="*Other*")*(('GCP Vendors'!O3:O999)= "Consultation")) I need to count the number of times a cell contains the partial string "Other" in the L column and then sum up how many of these strings are related to "Consultation" in the O column. I can't figure out how to substitute for "*Other*" in an array. Thanks, GP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wildcard not working in SumProduct Array | Excel Discussion (Misc queries) | |||
| How can I use the * wildcard in an array formula | Excel Worksheet Functions | |||
| VB Solution for a INDEX Array Problem | Excel Discussion (Misc queries) | |||
| Possible Array Solution Needed? | Excel Discussion (Misc queries) | |||
| Wildcard Character in an Array Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
