Counting option

P

Phil

Hi,

I have a bit of a problem when counting values, for example on sheet 2 in
the A colum you are allowed to select a value from a drop down, what I want
on sheet 1 is to be able to count the number of each of these options e.g.

A
 
M

Max

In Sheet1,
Assume you have listed the DV options in A1 down,
eg: A,B,C,D, ...

Then just place in B1:
=COUNTIF(Sheet2!A:A,A1)
Copy B1 down
 
Top