Everyone, please forget my last post, I found the problem. But now, I
have the following:

Of the three formulas below DMIN and DMAX work correctly in that when
the search in H1:R51 contains no '2 story homes', the result is a blank
cell, but DAVERAGE gives a result of #DIV/0! . Can anyone tell me why
this is so?

=IF(DMIN(Summary!H1:R51,"list
Price",A1:B2)=0,"",(DMIN(Summary!H1:R51,"list Price",A1:B2)))

=IF(DAVERAGE(Summary!H1:R51,"list
Price",A1:B2)=0,"",(DAVERAGE(Summary!H1:R51,"list Price",A1:B2)))

=IF(DMAX(Summary!H1:R51,"list
Price",A1:B2)=0,"",(DMAX(Summary!H1:R51,"list Price",A1:B2)))

DLS

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!