- ©«¤l
- 36
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 77
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-9-5
- ³Ì«áµn¿ý
- 2022-6-12
|
³o¼Ë¤l¬O§Anªº¶Ü¡H
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¥H¤W
=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)) |
|