your G8 formula should be =SUMPRODUCT(--('Bonus %'!$C$6:$C$15<=F8),--('Bonus %'!$E$6:$E$15>=F8),'Bonus %'!$G$6:$G$15)

but you should clearly define your bonus range in bonus% sheet
(ie bonus% C15 enter value 0% , E15 enter 89.99 also in row 6)