Counting occurrences in one column based on an occurrence in a
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.
|