grouping and subtotal by month

Hi
i want know how to count subtotals based on month.
Please see the below description'

I have three sheets in excel.

These sheets contain a column which has month name in it. Something like below

MONTH

Jun-06
Jun-06
Jun-06
Jun-06
Jun-06
Jun-06
Jul-06
Jun-06
Jul-06
Jul-06
Jul-06


I have a another sheet in which I need to calculate the number of records for each month. Something like below.
I should get data from the 3 sheets and populate the number of cases in that month in the fourth sheet.

Month-Year No of cases

Jan-06 0

Feb-06 0

Mar-06 0

Apr-06 0

May-06 0

Jun-06 7

Jul-06 4

Aug-06 0

and so on....


thanks in advance

You can use the COUNTIF function to do what you ask.

Assuming your Month column is in column A on Sheet1 and your Month-Year is in column A on Sheet2, use the following formula in column B on Sheet2:

=COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A1) adjust the $A$1:$A$100 range as needed

copy this formula down as far as needed.

NOTE: ensure the Month/Year data is EXACTLY the same on both sheets. If in date format, ensure the Excel dates match. Could also use a text entry such as " 'Jun-06 " in both sheets.

Good luck