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