View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
steven steven is offline
external usenet poster
 
Posts: 389
Default 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.