第一章 成绩查询常用函数............................................................................................................21．求和函数 SUM...................................................................................................................22．条件求和函数 SUMIF........................................................................................................33.逻辑函数 IF...........................................................................................................................34.平均值函数 AVERAGE........................................................................................................45．快捷方式或链接创建函数 HYPERLINK.........................................................................46．计数函数 COUNT..............................................................................................................57．条件计数函数 COUNTIF..................................................................................................58．最大值函数 MAX、最小值函数 MIN..............................................................................59 排序函数 RANK...................................................................................................................610.测函数 ISNUMBER............................................................................................................611、ISERROR 函数.................................................................................................................612、FREQUENCY 函数..........................................................................................................713、INDEX 函数.....................................................................................................................714、MATCH 函数....................................................................................................................715、VLOOKUP 函数....................................................................
