average if nothing is there

  • Thread starter Thread starter AAS
  • Start date Start date
A

AAS

=AVERAGE(IF(('Production Calendar'!C11:C101="Memco")*('Production
Calendar'!D11:D101="PLBF"),'Production Calendar'!G11:G101))

this equation works but if the are no PLBF, Memco employees yet is shows up
as #DIV/0!. If a PLBF, Memco employee is added I would like the equation to
recognize that there is now one present on worksheet 1. Any suggestions?
Thanks
 
Back
Top