My testing did not produce that result. Post your data and formula

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steven" wrote in message
...
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.