LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default Sumproduct with wildcard characters?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcard characters, IF functions PMBO Excel Worksheet Functions 1 November 15th 06 04:54 PM
wildcard characters Hasty Excel Discussion (Misc queries) 2 July 21st 06 10:40 AM
HELP: Wildcard Characters bbddvv Excel Discussion (Misc queries) 0 June 28th 06 02:38 PM
WildCard Characters Ralph Heidecke Excel Worksheet Functions 1 June 1st 06 07:43 PM
Using Wildcard characters in sumproduct Charles Excel Worksheet Functions 3 July 22nd 05 05:23 AM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"