Try this...

Sheet1 A1:C1 = Jan, Feb, Mar
Sheet1 A2:C10 = H, M, L

H = High
M = Medium
L = Low

Sheet2 A1 = drop down list containing the selections Jan, Feb, Mar

How to create a drop down list:
http://youtube.com/watch?v=t2OsWJijrOM

Sheet2 A3:A4 = H, M, L

Enter this formula in Sheet2 B2 and copy down to B4:

=COUNTIF(INDEX(Sheet1!A$2:C$10,,MATCH(A$1,Sheet1!A $1:C$1,0)),A2)

--
Biff
Microsoft Excel MVP


"Taza" wrote in message
...
Hi everyone - I hope someone can help me with this problem.

I have a simple table, with say Jan, Feb and March as headers in columns
A,
B and C. Under each one, I have a list of defined text values (High,
Medium
and Low).

On a seperate sheet, I want to count the number of times High, Medium and
Low occurs for each month.

But the tricky thing is this. On the seperate sheet I want one cell where
the user can select the month of interest (Jan, Feb and March) and then I
want the results to change depending on the month selected.

Any help much appreciated.