|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
AH2=IF(A2="","",SUM(COUNTIF(OFFSET(INDIRECT(TEXT(COLUMN(INDIRECT("C1:C"&MATCH(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99),TEXT(ROW($1:$12)&"-1","mmmm"),),))&"-1","mmmm")&"!B1:AG1"),MMULT(COLUMN(A:ALK)^0,COUNTIF(A2,T(OFFSET(INDIRECT(TEXT(COLUMN(INDIRECT("C1:C"&MATCH(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,99),TEXT(ROW($1:$12)&"-1","mmmm"),),))&"-1","mmmm")&"!A1"),ROW($1:$999),)))*ROW($1:$999)),),"<>"))) |
评分
-
2
查看全部评分
-
|