Wonderful! Thank you very much, this works as I was
hoping. Thanks again :)

Thanks to everyone for the responses

-----Original Message-----
You could just check first:

=if(countif(bj3:bj32,"<0")=0,"",SUMIF
(BJ3:BJ32,"<0")/COUNTIF(BJ3:BJ32,"<0"))



Randy Lefferts wrote:

=SUMIF(BJ3:BJ32,"<0")/COUNTIF(BJ3:BJ32,"<0")

I read a similar post where they needed to suppress the
error message above and the answer was to use =IF(COUNT
(B35:B47)0,AVERAGE(B35:B47,"") to eliminate the error.
Of course, this was in response to the specific formula
the person was using.

So I thought that I could use =IF(COUNT(B35:B47)0,
(insert my functions here),"") and that would work. It
doesn't appear to.

The spreadsheet has each month of the year, broken out
by
days. When the current month is September, there is
not
information in Oct, Nov and Dec. How to keep the
#DIV/0!
error from appearing in those months using =SUMIF
(BJ3:BJ32,"<0")/COUNTIF(BJ3:BJ32,"<0") ?

Thank you !

--

Dave Peterson
.