Formula to count within a Month

[stans]

I need to count how many visits were made within a given month per division.

Dates are entered in column D in the format mm/dd/yy.
The division is in column H.

I need the totals per month returned in the grid over the data area.

Any help is much appreciated. I cannot use a Pivot Table in this instance.

[HansV]

Enter the date 1/1/2010 in C3, 2/1/2010 in C4, then select C3:C4 and fill down to C14.
C3:C14 will still display the month names but contain actual dates.

Enter this formula in D3:

=SUMPRODUCT((DATE(2010,MONTH($D$21:$D$37),1)=$C3)*($H$21:$H$37=D$2))

Fill down to D14, then fill right to column H (or vice versa).

[stans]

Thanks just what I needed.