Excel常用函数

=IF (G2>20000,”优”,IF(G2>10000，”良”，”差"))

=SUMIF(A2:A13,D2,B2:B13)
A2:A13范围内，值为D2的所有行，B2:B13范围内求和

=SUMIFS(D29:D35,D29:D35,">=10000",D29:D35,"<=15000")
D29:D35范围内，满足条件>=10000,且 D29:D35范围内满足条件<=15000；求D29:D35范围的和

=COUNTIF(A2:A13,”>50")
A2:A13范围内，>50的，数量

=COUNTIFS(D29:D35,">=10000",D29:D35,"<=15000")
D29:D35范围内，满足条件>=10000,且 D29:D35范围内满足条件<=15000；的数量

=SUMPRODUCT(B2:B8*C2:C8)
B2:B8与C2:C8对应相乘，并求和

=IFERROR(A2/B2,"错误”)
A2/B2,"错误"

=TRIM(text) 去除空格