Posted to microsoft.public.excel.misc

external usenet poster

Posts: 2

How to avoid '*' being used as wildcard in SUMIF?

A data field for which I wish to do a SUMIF begins with the character "*".
e.g I have a Product Code of "*SPEC" where the * is the first character of a
5 character code. When I do a SUMIF the answer includes any row where the
Range value ends with the characters "SPEC".

I do not want the "*" being used as a wildcard in this instance.

All Suggestions welcome.

Issue arises in both Excel 2003 and Excel 2007.

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
sumif wildcard criteria	craig	Excel Worksheet Functions	1	January 6th 10 03:22 AM
sumif wildcard criteria	craig	Excel Worksheet Functions	1	January 6th 10 12:15 AM
Wildcard with sumif	fractallinda	Excel Discussion (Misc queries)	13	March 13th 09 05:02 PM
Sumif using wildcard	claireanddoug	Excel Worksheet Functions	1	September 22nd 05 10:17 PM
SUMIF, wildcard and cell ref	Dave	Excel Worksheet Functions	2	January 31st 05 08:13 PM

All times are GMT +1. The time now is 12:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us