山菊花 =SUM(INDIRECT(ADDRESS(ROW(INDIRECT("A"&MATCH(VLOOKUP('01'!D4,Dte1!A:A,1,),Dte1!A:A,)))+'01'!G4,6)):INDIRECT(ADDRESS(ROW(INDIRECT("A"&MATCH(VLOOKUP('01'!D4,Dte1!A:A,1,),Dte1!A:A,)))+'01'!I4+1,6))) =IF(A2='01'!D$4,'01'!F$4,) =SUMPRODUCT((INDIRECT(ADDRESS(ROW(A50)+1,6)):INDIRECT(ADDRESS(ROW(A56)+1,6)))*(INDIRECT(ADDRESS(ROW(A50)+1,7)):INDIRECT(ADDRESS(ROW(A56)+1,7)))) =SUM(INDIRECT(ADDRESS(ROW(INDIRECT("A"&MATCH(VLOOKUP('01'!D4,Dte1!A:A,1,),A:A,)))+'01'!G4,6)):INDIRECT(ADDRESS(ROW(INDIRECT("A"&MATCH(VLOOKUP('01'!D4,Dte1!A:A,1,),A:A,)))+'01'!I4+1,6))) =OFFSET(A50,1,5) ="A"&MATCH(VLOOKUP('01'!D4,Dte1!A:A,1,),A:A,) =SUM(Dte1!$F$1:Dte1!$F$10) 请教高手公式中的D4\G4\I4改成D列\G列\I列\F列怎么改才使所有公式有将效.谢谢 现在公式只是01表第四行有效,我想改成01表D列\G列\I列\F列都有效.谢谢
[此贴子已经被作者于2008-9-13 10:00:22编辑过] |