Get existing cars from a list

[Immortal2014]

Hi, in the workbook i need to take automatically the numbers of cars but by list. I explain inside the workbook. Thanks in advance.

[mikeTRON]

Can you use a pivot table instead of formulas?

[Immortal2014]

I have no idea fron pivot.. I dont know..

[alansidman]

Click here and scroll down for several tutorials on Pivot Tables.

http://www.datapigtechnologies.com/ExcelMain.htm

[Immortal2014]

Thanks for the link, i really must say, i didnt understand nothing!!
Is there a way to be done with a formula?

[alansidman]

Here is a PT that I developed. Will this work for you.

[Immortal2014]

Thanks for your time and for your PT, i think if i must to continue with PT i have to do this by myself because real workbook its more complicated and i have more data, this workbook its just an example. So, i need first to understand what is PT and how it works, maybe your link will help me. Anyway, thanks again for help and sorry for my bad english.