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.
--
joe s

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Joe S" wrote:

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.
--
joe s

yeah! Thank you so much.

by the way, I am using XL 07.
--
joe s


"Luke M" wrote:

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Joe S" wrote:

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.
--
joe s