Try this:

=SUMPRODUCT(--(ISNUMBER(SEARCH("osh",SI_DES))),--(ISSUED=--"3/1/2007"),--(ISSUED<=--"3/31/2007"))

Note that SEARCH is not case sensitive. SEARCH will work for both "osh" and
"OSH". If you explicitly want to match uppercase "OSH" replace SEARCH with
FIND:

=SUMPRODUCT(--(ISNUMBER(FIND("OSH",SI_DES))),--(ISSUED=--"3/1/2007"),--(ISSUED<=--"3/31/2007"))

--
Biff
Microsoft Excel MVP


"Disdan" wrote in message
...
Hi, I have the following sample data

I have data identifing (1) the description of a document issued (column
ranged named SI_DES) and (2) the date it was issued (Column range called
ISSUED).

I am able to use the COUNTIF function to count the number of times the
term
"OSH" occurs in the description to determine the number of OSH documents
are
identified in the total list. - The formula I use is
=COUNTIF(SI_DES,"*OSH*").

I am also able to count the number of if times any given document is
issued
per month - The formula I use is
=(COUNTIF(ISSUED,"=3/1/07")-COUNTIF(ISSUED,"3/31/07"))

What I am having troble with is counting the number of OSH documents that
are issued in a given month. I am having troble combing the two formulas
above to generate to answer. If any one can help, it would be much
appreciated.

Thanks