Scorpvin

Posts: n/a

Wildcard Character in an Array Formula

Does anybody know how to write an array formula that includes a wildcard
character such as ? or *

I'm using a simple SUM(IF) array.

=SUM(IF((C6:C25="*Wiscons*"),E6:E25,0))
Ctrl+Shift+Enter

--
Scorpvin
------------------------------------------------------------------------
Scorpvin's Profile: http://www.excelforum.com/member.php...o&userid=27678
View this thread: http://www.excelforum.com/showthread...hreadid=472133

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Editing Array Formula	[email protected]	Excel Worksheet Functions	7	August 28th 05 06:46 AM
Array Formula	Karen	Excel Worksheet Functions	2	June 7th 05 06:49 PM
Array Formula	frankybenali	Excel Worksheet Functions	1	February 16th 05 06:37 PM
What instead of an array formula part 2	Reg Besseling	Excel Discussion (Misc queries)	2	December 10th 04 07:35 AM
What instead of an array formula?	Reg Besseling	Excel Discussion (Misc queries)	3	December 6th 04 01:55 PM

All times are GMT +1. The time now is 09:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us