If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#DIV/0! error with DAVERAGE Function
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) |
#2
|
|||
|
|||
#DIV/0! error with DAVERAGE Function
--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 --------------- Jacob Skaria "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) |
#3
|
|||
|
|||
#DIV/0! error with DAVERAGE Function
=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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "KLocken" wrote in message ... 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) |
#4
|
|||
|
|||
#DIV/0! error with DAVERAGE Function
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)) -- David Biddulph "KLocken" wrote in message ... 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) |
#5
|
|||
|
|||
#DIV/0! error with DAVERAGE Function
try,
=if(iserror(DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33)),"",DAVERAGE('Perm Recruitment'!A:R,"Days To Fill",D32:F33)) "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) |
#6
|
|||
|
|||
#DIV/0! error with DAVERAGE Function
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 -- 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) |
Thread Tools | |
Display Modes | |
|
|