you mean?
confirmed with CTRL+SHIFT+ENTER![]()
=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))
you mean?
confirmed with CTRL+SHIFT+ENTER![]()
=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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks