=LET(a,$P$2:$P$9,b,$Q$2:$Q$9,c,$R$2:$R$9,d,$B$13:$B$15,e,$C$12:$M$12,f,$C$13:$M$15,x,C$1,y,$A2,z,FILTER(a,b=y),SUM(ROUNDUP(XLOOKUP(z&","&y,a&","&b,c)*IFERROR(INDEX(f,MATCH(z,d,),MATCH(x,e,)),0),0)))
每个小项都需要向上取整的话,SUMPRODUCT不能用了,需要分别相乘之后roundup向上取整,最后在SUM相加