Found it on another forum. Sweet! Knew it couldn't be that difficult

=IF(OR(B2="",D2=""),"",AVERAGE(B2,D2))