#DIV/0! error with DAVERAGE Function

[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)

 

[Jacob Skaria]

--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

 

[Bernard Liengme]

=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

 

[David Biddulph]

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))

 

[Eduardo]

try,

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

 

[Shane Devenshire]

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

where D is the "Days To Fill" column