grouping and subtotal by month

[bix]

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

 

[swatsp0p]

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

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

=COUNTIF(Sheet1!$A$1:$A$100,Sheet2!A1) adjust the $A$1:$A$100 rang
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 tex
entry such as " 'Jun-06 " in both sheets.

Good luc