Hallo,
I hope someone out there has more brains than I.
Trying to get formula to display "" or 0 as opposed to the dreaded #DIV/0!
{=AVERAGE(IF((TFL!$J$1:$J$9999)=(Summary!B229),TFL!$W$1:$W$9999))}
I have tried various IF's to get the problem to go bye-bye but it keeps sticking like double sided tape.
Regards,
Donovan.
Ps. An why do I always end up with these problems on Friday afternoon or is that a mental shutdown process in action?
Bookmarks