Weighted averages with multiple criteria

[Jps62]

I need major help…how can I calculate the weighted average of the probability of default score (column C) using the associated Risk Grade (column D) on all types (column A) that are >=400 and <= 410 that also have a credit range (column F) A (729-700) at location (column E) of 80? Any direction would be so appreciated.

Thanks

[Ace_XL]

Not entirely sure but try

=SUMPRODUCT(($A$2:$A$190>=400)*($A$2:$A$190<=410)*($F$2:$F$190="A (729-700)")*($E$2:$E$190=80)*$C$2:$C$190*$D$2:$D$190)