countif would really work here
one option is Sumproduct()
=sumproduct(--(F$2:F$133="Region 1"),--(G$2:G$133<""))
the --( changes the logical true false to a numeric 1,0. the arrays in each
section must be the same size but cannot be the short hand for full columns
or rows

"klam" wrote:

I have different Regions listed in Column F and will enter dates (dd-MMM ) in
Column G when a certain event happens. I would like to count the number of
occurances for each Region only if there is a date in Column G.

I am using the array formula:

=COUNT(IF(F$2:F$133="Region 1",G$2:G$133))

but it returns the number of occurances of "Region 1", instead of counting
the number of times a date shows up in G2 to G133.

Can anyone see what I am doing wrong?

Excel 2000 on XP
cheers,