本帖最后由 liziyuliziyu7 于 2014-6-30 16:24 编辑
再增加一变 , =MAX((T(OFFSET(D$2,ROW($1:$12),))=H3)*C$3:C$14) 看的眼花,不知道有没有这个
=sum((T(OFFSET(D$2,ROW($1:$12),))=H3)*C$3:C$14)
=MAX(IF(T(OFFSET(D$2,ROW($1:$12),))=H3,C$3:C$14))
=SUM(IF(T(OFFSET(D$2,ROW($1:$12),))=H3,C$3:C$14))
=MMULT(TRANSPOSE(N(T(OFFSET(D$2,ROW($1:$12),))=H3)),C$3:C$14)
=LOOKUP(,0/(T(OFFSET(D$2,ROW($1:$12),))=H3),C$3:C$14)
=INDEX(C3:C14,MATCH(H3,T(OFFSET(D$2,ROW($1:$12),)),))
=OFFSET(C2,MATCH(H3,T(OFFSET(D$2,ROW($1:$12),)),),)
=INDIRECT("c"&MATCH(H3,T(OFFSET(D$2,ROW($1:$12),)),)+2)
……………………
|