View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default #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)