Counting Values

[Guest]

Hi,

On sheet 2 column A you are allowed to enter values from a drop down, what I
want to be able to do on sheet 1 is count the number of times each of these
options appear.

Example

Sheet2

A
1 Ford
2 Vauxhall
3 Toyota
4 Ford
5 Toyota

Sheet 1

Type Number
Ford 2
Vauxhall 1
Toyota 2


Hope someone can help

Thanks PD

 

[Dave Peterson]

Put your list in column A of Sheet1.
Then use a formula like this in B1:
=countif(sheet2!a:a,a1)
and drag down.