Posted to microsoft.public.excel.misc

steven

external usenet poster

Posts: 389

If text already contains a wildcard how do I countif, sumif etc.?

From a database one of the dataset contains a vehicle type for example
pushbike, small van etc. however if the booking is made online it precede the
vehicle type with an * meaning if I countif, sumif pushbike it counts both
types of records.

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
Wildcard with sumif	fractallinda	Excel Discussion (Misc queries)	13	March 13th 09 05:02 PM
COUNT or COUNTIF using wildcard text?	WiFiMike2006	Excel Worksheet Functions	11	January 12th 07 11:12 PM
Need help on countif and sumif function with dates and wildcard characters	chinita_jill	Excel Discussion (Misc queries)	5	July 19th 06 05:22 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:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us