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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Phil" wrote:
> 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