- ©«¤l
- 13
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 50
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2018-10-5
- ³Ì«áµn¿ý
- 2020-7-10
|
[µo°Ý] ¦p¦ó¥Îcountifs¼g¥X¤£«½Æªºpºâ
¦U¦ì¤j¯«
¦p¦ó¥H¨ç¼Æpºâ¬Y¤@¤ë¥÷ªº¬Y¤@½u§Oªº¤£²b¯ÊÂIªº§å¸¹¼Æ
¨Ò¦p¡G®Æ¸¹910G¦b2018-M01©óD02½u§O¤¤¡A¦³2§å¦³²£¥Í¤£²b³oÓ¯ÊÂI
¥H¤U¬°¤p§Ì¼gªº³¡¤À¨ç¼Æ
countifs(A:A,"D02",B:B,"2018-M01",D:D,"910G",F:F,">=1")
¤p§Ì¾ÇÃÀ¤£ºë¤£ª¾¹D«ç»òÅý§å¼Æ¤£«½Æªºpºâ¡A¨ç¼Æ¼g¨ì³o¸Ì´N¥d¦í¤F
Àµ½Ð¤j¯«À°À°¤p§Ì·P¿E¤£ºÉ
|
|