- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 6# prince0413
°ª¶¯·~ÁZ¤ÀªR_ML089.rar (109.74 KB)
L15
=SUM(COUNTIFS($G:$G,LEFT(L$8,3),$D:$D,"*"&MID($J15&"X",1,7)&":"&{1,2,3,4,5,6,7,8,9}&"*")*{1,2,3,4,5,6,7,8,9}, COUNTIFS($G:$G,LEFT(L$8,3),$D:$D,"*"&MID($J15&"X",9,7)&":"&{1,2,3,4,5,6,7,8,9}&"*")*{1,2,3,4,5,6,7,8,9})
¤½¦¡¿é¤J«á¡A¥i½Æ»s¶K¦Ü¶À¦â°Ï
¤½¦¡¥u¯à§@ 1~9 ¼Æ¶q¤Î1~2«~¸¹ |
|