发布时间 : 星期日 文章Excel函数习题集更新完毕开始阅读fbac3356cc22bcd127ff0c1a
FIND REPLACELEN SUBSTITUTECHAR SUBSTITUTE
REPLACE LENB LEN CHARREPLACE LENB LEN CHAR
IF EXACT LEFT UPPER /IF AND ROW CODE LEFTREPT IF
REPLACE FIND REPTIF REPT INT
TRIM RIGHT SUBSTITUTE REPTTEXT
IF /TEXT /CHOOSE
IF OR LEFT RIGHT COLUMN SUM TEXT
VLOOKUP IF /VLOOKUP CHOOSE COLUMN ROWCHOOSE MOD YEARINDIRECT COUNTA
SUM TEXT MID ROW /SUM TEXT MID ROW INDIRECT LENINDIRECT CHAR MOD INT ROWINDIRECT COLUMN ROW
MAX MMULT SUBTOTAL OFFSET ROWMIN MAX IFMAX MIN IFSUM /SUMIFS
RANK /COUNTIF SUMSUMIF SUMDATEDIF IF
GET.CELL N SUM SUMIF COUNTAGET.CELL COUNTIF
VLOOKUP /HLOOKUP TRANSPOSESMALL IF ROW INDEX
IF ROW SMALL INDEX /INDEX SMALL IF MMULT N TRANSPOSE ROWLARGE SMALL COUNTIF IF SUM NSUBTOTAL SUM /SUM MAX MINFREQUENCY /COUNTIFFREQUENCY COUNT
MATCH FREQUENCY COUNTMMULT /SUM
SUM /SUMPRODUCT N /MMULT TRANSPOSEMMULT TRANSPOSE N
SUM INDEX N IF MATCH ROWSUM VLOOKUP T IF
MAX /MAX INDEX MATCHMMULT SUMIF
MATCH MAX INDEX
OFFSET MATCH COUNTIF
SUM COUNTIF /SUM COUNTIF OFFSET ROWAVERAGE MAX /MAX SUBTOTAL OFFSET ROWSUM IF INDEX MATCH
SMALL OFFSET ROW COLUMNRIGHT SMALL ROW COLUMNLOOKUP ROW COLUMNLOOKUP ROW
MMULT ROW /N TRANSPOSE MMULT ROW /COUNTIF
MID COLUMN
TEXT SMALL IF ISERR FIND ROW COLUMNTEXT SMALL IF ISERR FIND ROW COLUMNCHOOSE TRANSPOSE ROWIF ROWIFTEXT
MID FIND SUBSTITUTE TRANSPOSE ROWINDEX TRANSPOSE ROWCHOOSE TRANSPOSE ROWINDIRECT CHAR CODEIF ROW LOOKUPIF ROW LOOKUP
MID /TRUNC LEN /RIGHT LEN /REPLACE REPT LEN /LEFT LENMMULT ROW