#DIV/0! error with DAVERAGE Function

  • Thread starter Thread starter KLocken
  • Start date Start date
K

KLocken

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)
 
--Make sure D32 and F32 are having the table headers (exactly same as the
header in the table A:R)
--In D33 and F33 check for valid criterias which are available in the data.

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

If this post helps click Yes
 
=IF(ISERROR(DAVERAGE('Perm Recruitment'!A:R,"Days To
Fill",D32:F33)),"",DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33))

In general
=IF(ISERROR(you-formula), what-you-want-when_there_is_an_error,
your_formula)


A bit simpler in Excel 2007
=IFERROR(your_formnula, what-you-want-when_there_is_an_error)
note that the formula occurs just once.

best wishes
 
You might try =IF(DCOUNT('Perm Recruitment'!A:R,"Days To
Fill",D32:F33)=0,"",DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33))
 
try,

=if(iserror(DAVERAGE('Perm Recruitment'!A:R,"Days To
Fill",D32:F33)),"",DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33))
 
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
 
Back
Top