如何查找excel 表格中某行某列所对应的单元格数据,并且将此数据汇总到...答:如图,图1加一辅助列F F2=COUNT(B2:E2)图2:A2=OFFSET(Sheet1!$A$1,LOOKUP(ROW()-2,SUBTOTAL(9,OFFSET(Sheet1!$F$1,,,ROW($1:$5),)),ROW($1:$5)),,,)B2=OFFSET(Sheet1!$A$1,,SMALL(IF(OFFSET(Sheet1!$B$1,MATCH(A2,Sheet1!$A$2:$A$5,0),,,4)>0,COLUMN($A:$D)...