The formula works so well it solves another problem. There are instances
where two names appear such as John/Jane instead of the usual single name.
Both names need to be credited with that appearance and this formula takes
care of that as well.

Thanks you for helping save my sanity.

Jim

"Ron Coderre" wrote:

If you are looking to match if "fred" is located anywhere in the cell (eg The
Fred Company) for the month of MAR 2005, try using this variant of Bob's
formula:

=SUMPRODUCT(--ISNUMBER(FIND("fred",B1:B100)),--(A1:A100=--"2005-03-01"),--(A1:A100<=--"2005-03-31"))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jim Jackson" wrote:

=COUNTIF((B2:B1000),"*Fred*")-(COUNTIF((A2:A1000),"=3/1/2005")-(COUNTIF((A2:A1000),"=4/1/2005")))

This is the formula I am trying to get to work. This does not work as it
stands. It returns a "7" when there are five dates in the Dates column and
No "Fred"s in the names column.

I think I am close but can't seem to get any further.

Jim

"Ron Coderre" wrote:

Do the date ranges actually contain text (JAN06, MAR06, etc)?
or do they contain actual dates (1/12/2006, 2/13/06,etc)?

It makes a big difference in the kind of solution you need.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jim Jackson" wrote:

I have one column with names and another with date ranges (JAN06) etc. I
want to count the number of times a name occurs within a given date range.