No the num error is returned by other reasons, if the arrays are different
in size it will be returned or if the named ranges you are using are
defining the whole column, meaning that

A1:A65535

will work but

A:A

will not

whereas SUMIF will work with whole ranges



--


Regards,


Peo Sjoblom


"Disdan" wrote in message
...
Hi Peo,

Thanks for yout help, I tried the function you suggested and it gives me
the
#NUM error. SI_DES column is text and ISSUED is date. I think this is why
the
function returned this error. Below is some sample data to better
demonstrate
what I am trying to do.

SI_DES(text format) ISSUED(date format)
OSH1 1/1/2007
doc1 1/5/2007
OSH2 1/6/2007
OSH3 1/25/2007
doc2 2/3/2007
OSH4 2/5/2007

The function I am trying to create is to answer is "how many OSH documents
were issued in January 2007". The answer is 3.

I hope this better clarifies the problem
Thanks - David

"Peo Sjoblom" wrote:

Try

=SUMPRODUCT(--(YEAR(ISSUED)=2007),--(MONTH(ISSUED)=3),--(ISNUMBER(SEARCH("OSH",SI_DES))))



--


Regards,


Peo Sjoblom



"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