finding the number of occurences
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
|