官方认定:Excel中最常用的10个函数,你会几个?(上篇)
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
TOP1:SUM函数
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
=SUM(N(D3:D7=B11))
![](http://n4.ikafan.com/assetsj/blank.gif)
=SUM((D3:D7=B11)*(F3:F7))
![](http://n4.ikafan.com/assetsj/blank.gif)
TOP2:IF函数
![](http://n4.ikafan.com/assetsj/blank.gif)
=IF(D3>C3,"是","否")
![](http://n4.ikafan.com/assetsj/blank.gif)
=IF(C3<60,"C",IF(C3<80,"B","A"))
![](http://n4.ikafan.com/assetsj/blank.gif)
TOP3:LOOKUP函数
向量形式:LOOKUP(lookup_value, lookup_vector, [result_vector])
数组形式:LOOKUP(lookup_value, array)
向量形式 =LOOKUP(C3,$F$7:$F$9,$G$7:$G$9)
![](http://n4.ikafan.com/assetsj/blank.gif)
数组形式 =LOOKUP(C3,$F$7:$G$9)
![](http://n4.ikafan.com/assetsj/blank.gif)
=LOOKUP(1,0/($B$3:$B$11=F3),$C$3:$C$11)
![](http://n4.ikafan.com/assetsj/blank.gif)
TOP4:VLOOKUP函数
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
=VLOOKUP(J4,$C$3:$D$12,2,0)
![](http://n4.ikafan.com/assetsj/blank.gif)
=VLOOKUP(C17&D17,CHOOSE({1,2},$C$4:$C$14&$D$4:$D$14,$F$4:$F$14),2,0)
![](http://n4.ikafan.com/assetsj/blank.gif)
VLOOKUP基础入门-案例大全 VLOOKUP进阶学习-案例大全 视频详解VLOOKUP如何实现1对多查找! 20多个经典案例:视频教程(扫码学习)
![](http://n4.ikafan.com/assetsj/blank.gif)
TOP5:MATCH函数
![](http://n4.ikafan.com/assetsj/blank.gif)
![](http://n4.ikafan.com/assetsj/blank.gif)
=MATCH(B3,$E$2:$E$5,1)
![](http://n4.ikafan.com/assetsj/blank.gif)
=SUM(N(MATCH(B3:B9,B3:B9,)=ROW(B3:B9)-2))
![](http://n4.ikafan.com/assetsj/blank.gif)
赞 (0)