主題: Excel的Lookup公式問題
瀏覽單個文章
airitter
Master Member
 
airitter的大頭照
 

加入日期: Sep 2003
文章: 2,102
=SUMPRODUCT(LOOKUP(B2:I2,{"a","b","c",0},{8,6,4,0}))
__________________
[ExtremeTech]VGAMaster
舊 2015-09-28, 01:58 PM #6
回應時引用此文章
airitter離線中