finding the number of occurences

[Joe S]

I can't work out the formula to find the number of times say, "CT" has a
visit date.

My data looks like this:
(column 3 and 4 has last name and first name)
Column2 Column5
State Visit Date
CT
CT 2/18/09
CT
ME
NH 1/19/09

I have tried countifs but don't know how to tell it to recognize entry in
cell. Actual date is not important. Just the State and the number of times a
date occurs with the State.
Any help at all from anyone would be greatly appreciated.
Thanks.

 

[Luke M]

Something like...
=SUMPRODUCT((B2:B100="CT")*(ISNUMBER(E2:E100)))

Note that Range sizes must be equal, and you can't callout the entire column
(Unless using XL 2007)

 

[Joe S]

yeah! Thank you so much.

by the way, I am using XL 07.