=sumproduct($b$3:$b$42,$c$3:$c$42,--($a$3:$a$42>=e8),--($a$3:$a$42<=f8))/sumproduct($b$3:$b$42,--($a$3:$a$42>=e8),--($a$3:$a$42<=f8))