計算工资與奖金 (10403)

L2:M9=SUMPRODUCT(OFFSET($C$1,LOOKUP(1,0/($B$2:$B$17=$K2),ROW($1:$16)),,,7)*COUNTIF(IF($A$1=A$1,O$3:O$5,$O$9:$O$12),$C$1:$I$1))