求大佬帮忙优化下函数公式，做一个自己的每日记工表

=IF(AND(B5="1米48",D5="是"),SUM(I5*C5*1.1))
=IF(AND(B5="1米48",D5="否"),SUM(I5*C5*1))
=IF(AND(B5="1.5米48",D5="是"),SUM(I6*C5*1.1))
=IF(AND(B5="1.5米48",D5="否"),SUM(I6*C5*1))
=IF(AND(B5="2米48",D5="是"),SUM(I7*C5*1.1))
=IF(AND(B5="2米48",D5="否"),SUM(I7*C5*1))
=IF(AND(B5="1米60",D5="是"),SUM(K5*C5*1.1))
=IF(AND(B5="1米60",D5="否"),SUM(K5*C5*1))
=IF(AND(B5="1.5米60",D5="是"),SUM(K6*C5*1.1))
=IF(AND(B5="1.5米60",D5="否"),SUM(K6*C5*1))
=IF(AND(B5="2米60",D5="是"),SUM(K7*C5*1.1))
=IF(AND(B5="2米60",D5="否"),SUM(K7*C5*1))

=lookup(1,0/(b5={"1米48","1.5米48","2米48","1米60","1.5米60","2米60"}),c5*(1+(D5="是")/10)*{I5,I6,I7,K5,K6,K7})

看这个有数据对照表，可以=sumproduct((h$5:j$7=b5)*i$5:k$7)*c5*vlookup(d5,h$12:i$13,2,0)

ok已经很简洁了，谢谢大佬们支持 @彩虹蓝宝石 @抖/头条阿管gg