轉置表格 (10761)


N5:W13=SUMIFS(OFFSET($C$3:$C$27,,MOD(ROW(A3),3)),$A$3:$A$27,OFFSET($M$5,INT(ROW(A3)/3)*3-3,),$B$3:$B$27,N$4)


留言