Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using the following formula successfully as long as the criteria is
exact. The challenge is that the service request description field begins with the specific indentifiers that identify what type of service request was resolved in the case below "wb" standing for "walk bys" them followed by further details. Using Countifs I can use a wildcard "wb*" and it works perfectly. I am using Office 2007 and the problem is that Countifs is not supported in Office 2003. What works if data is only "wb" =SUMPRODUCT((Data2!A1:A500='2007'!A13)*(Data2!C1:C 500="wb")) What is needed is to count "wb-........" Tried below to no avail =SUMPRODUCT((Data2!A1:A500='2007'!A13)*(Data2!C1:C 500="wb*")) Any ideas as to how to best relove this? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wildcard characters, IF functions | Excel Worksheet Functions | |||
wildcard characters | Excel Discussion (Misc queries) | |||
HELP: Wildcard Characters | Excel Discussion (Misc queries) | |||
WildCard Characters | Excel Worksheet Functions | |||
Using Wildcard characters in sumproduct | Excel Worksheet Functions |