Yahoo奇摩 網頁搜尋

  1. 依您的資料, 做個範例: http://www.funp.net/265991 Sheet2之B2公式為: B2=SUMPRODUCT((Sheet1!$A$2:$A$1000<=$A2)*(Sheet1!$B$2:$B$1000>$A2)*(Sheet1!$C$2:$C$1000...