回血老师真的好准

如题所述

第1个回答 2021-10-18
DDB″老师“(զ:‚789—078‚63) 求“采‹纳— =IF(A3="","",OFFSET(AD$1,MAX(IF(ISFORMULA(AD$2:AD3),0,ROW(AD$2:AD3)))-1,0)) =--left(index(Match()),len(index(Match()))-1)substitude:=substitute(index(Match()),"","") =TEXTJOIN("、",TRUE,IF(C2:C3000>2000,B2:B300,""))=TEXTJOIN("、",TRUE,IF((A2:A3000>=F10)*(A2:A3000=2000),B2:B3000,"")) =SUMIF(INDIRECT("'"&$B5&"'!A11:A19"),N$3,INDIRECT("'"&$B5&"'!B11:B19")) 本回答被提问者采纳
本回答被提问者采纳