Hi,

You can get DIV/0 errors from the D functions if 1. the Criteria title does
not match any title in the database area. 2. if no entries meet your
criteria, 3. If you did not include the title row of the data area as part of
the first argument in the D function, which obviously is not the case with
your range.

In 2007 you can handle the 2nd one of these with

=IFERROR(DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33),"")

Although it makes the formula clearer you might consider replacing "Days To
Fill" with either the column number (withing the database range) or
referencing the cell containing that name.

In 2003 you can handle the 2nd one with

=IF(ISERR(DAVERAGE('Perm Recruitment'!A:R,"Days To
Fill",D32:F33),"",DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33))

or shorter:

=IF(SUM('Perm Recruitment'!D:D)=0,"",DAVERAGE('Perm Recruitment'!A:R,"Days
To Fill",D32:F33))

where D is the "Days To Fill" column


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"KLocken" wrote:

Please advise how to fix a #DIV/0! error with a daverage function.

Function string is below and returning #div/0 error

=DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33)