- 帖子
- 195
- 主題
- 17
- 精華
- 0
- 積分
- 242
- 點名
- 183
- 作業系統
- windows xp
- 軟體版本
- office 2007
- 閱讀權限
- 20
- 性別
- 男
- 註冊時間
- 2011-8-8
- 最後登錄
- 2026-8-2
            
|
本帖最後由 aer 於 2013-11-11 20:51 編輯
圖一 F1=SUMIFS(D2 95,D295,">100",B2:B95,"<="&DATEVALUE("2000/12/31"))
G1=SUMIFS(G2:G95,G2:G95,">100",B2:B95,"<="&DATEVALUE("2000/12/31"),A2:A95,1)
圖二 F1=SUMIFS(D295,A2:A95,2,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),D295,">100")
G1=SUMIFS(G2:G95,A2:A95,2,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),G2:G95,">100")
圖三 F1=SUMIFS(D295,A2:A95,1,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),D295,">100")
G1=SUMIFS(G2:G95,A2:A95,1,B2:B95,">"&DATEVALUE("2008/1/1"),B2:B95,"<="&DATEVALUE("2008/12/31"),G2:G95,">100") |
|
發表於 2013-11-11 20:46
| 