G
Guest
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,
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,