Posted to microsoft.public.excel.worksheet.functions

Craig

external usenet poster

Posts: 208

sumif wildcard criteria

I cant seem to get the wild card to work in a simple SUMIF
My criteria data is as follows
579910001
569410001
538610001
.......Etc

The criteria I want use is 10001

I have tried
=SUMIF(Plan!$A1:$A1000,"5*10001",Plan!C1:C1000)
=SUMIF(Plan!$A1:$A1000,"5***10001",Plan!C1:C1000)
=SUMIF(Plan!$A1:$A1000,"5???10001",Plan!C1:C1000)
and other variations....

Is there something simple I am not seeing.
Best Rgd Craig

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 12:15 AM
Wildcard with sumif	fractallinda	Excel Discussion (Misc queries)	13	March 13th 09 05:02 PM
Nesting SUMIF with Wildcard	ShannaD	Excel Worksheet Functions	3	January 14th 08 07:39 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 09:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us