- ©«¤l
- 57
- ¥DÃD
- 21
- ºëµØ
- 0
- ¿n¤À
- 83
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-9-18
- ³Ì«áµn¿ý
- 2022-9-13
|
¦^´_ 4# hcm19522
SUMPRODUCT((MATCH(A2:A10,A2:A10,)=ROW(A2:A10)-1)*(B2:B10=1)*(C2:C10<14))
¥i¥HÀ°¦£»¡©ú¨ç¼Æ³£¥Î·N¶Ü? ¨Ò¦pROW(A2:A10)-1) ¬°Ô£n-1 ¨ú³oÓÈ¥i¥H°µ¤°»ò? |
|