總和 有固定跳格數 (9430)

 

  Q3:T4=SUMPRODUCT(($A$2:$P$2=Q$2)*$A3:$P3)

另解=SUMIF($A$2:$P$2,Q$2,3:3)

另解{=SUM(N(OFFSET(A3,,4*ROW($1:$4)-4)))