杂记 #SUMPRODUCT 隔9列取值 SUMPRODUCT((MOD(COLUMN(C599:DQO599),9)=8)*1,C599:DQO599) 隔2行取值 SUMPRODUCT((MOD(ROW(G10:G1000),2)=0)*1,G10:G1000) #LOOKUP VLOOKUP HLOOKUP