- 帖子
- 36
- 主題
- 6
- 精華
- 0
- 積分
- 77
- 點名
- 0
- 作業系統
- Win7
- 軟體版本
- office2003
- 閱讀權限
- 20
- 性別
- 男
- 註冊時間
- 2013-9-5
- 最後登錄
- 2022-6-12
|
這樣子是你要的嗎？
0-30
=SUMPRODUCT(ISNUMBER(FIND(LEFT($A$2:$A$364,1),$M6))*(MONTH($E$2:$E$364)=$L6)*($J$2:$J$364<=30)*($G$2:$G$364))
31-70
=SUMPRODUCT(ISNUMBER(FIND(LEFT($A$2:$A$364,1),$M6))*(MONTH($E$2:$E$364)=$L6)*($J$2:$J$364<=70)*($G$2:$G$364))-SUMPRODUCT(ISNUMBER(FIND(LEFT($A$2:$A$364,1),$M6))*(MONTH($E$2:$E$364)=$L6)*($J$2:$J$364<=30)*($G$2:$G$364))
71-95
=SUMPRODUCT(ISNUMBER(FIND(LEFT($A$2:$A$364,1),$M6))*(MONTH($E$2:$E$364)=$L6)*($J$2:$J$364<=95)*($G$2:$G$364))-SUMPRODUCT(ISNUMBER(FIND(LEFT($A$2:$A$364,1),$M6))*(MONTH($E$2:$E$364)=$L6)*($J$2:$J$364<=70)*($G$2:$G$364))
96以上
=SUMPRODUCT(ISNUMBER(FIND(LEFT($A$2:$A$364,1),$M6))*(MONTH($E$2:$E$364)=$L6)*($J$2:$J$364>95)*($G$2:$G$364)) |
|
發表於 2013-10-19 08:40
| 