average if nothing is there

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averaging info from three columns 5
Getting an average using if statement 3
Average formula multiple worksheets 1
average cells, show 0 if nothing to average 8
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5
if cell in other worksheet meets criteria, then leave blank. 1
Average the last eight or nine (Variable) numbers in a row. 3
Is there a way for excel to recognise that €0.00 = 0 for the purposes IF function ? 4

Top