EXCEL中sumproduct怎么嵌套if函数？急求高手帮忙解答！！

=MAX(IF($A$2:$A$18=$E6,$B$2:$B$18)) =SUM(F6:F8)