View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Taza Taza is offline
external usenet poster
 
Posts: 4
Default Summing a column based on input in a cell

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.