you mean?

=sum(if(isnumber(match($a$3:$a$25,$e$3:$e$12,0)),$b$3:$b$25*$c$3:$c$25))/sum(if(isnumber(match($a$3:$a$25,$e$3:$e$12,0)),$c$3:$c$25))
confirmed with CTRL+SHIFT+ENTER