I answered too soon it seems. After shooting back my reply I thought to try
the formula. It has worked each of the several times I have tried it with
varying date ranges and names.

Thanks,

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.