Recognise and count specific words

[BBoyAl]

Hi, who would mind helping with this one.

I am trying to count how many cars are sold and how many commercial vehicles are sold. At the moment (as you will be able to see from the spreadsheet clip I have uploaded) I have used some simple sums to get the correct totals to calculate.

What I would ideally like the spreadsheet to do is automatically populate the "Used Car" and "Commercial" totals from the information in column D.

FYI..... TRANSIT and CONNECT are commercial vehicles and FIESTA, FOCUS and MONDEO are cars.


Any assistance is greatly appreciated.