Counting option

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 12 Mar 2007 16:48 GMT

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

Reply to this Message

Max - 13 Mar 2007 03:15 GMT

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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Hi,
>
[quoted text clipped - 3 lines]
>
> A

Reply to this Message