ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

§Q¥Î¤é´Á¨Ó¥[Á`·í¤éª÷ÃB¥X¿ù

§Q¥Î¤é´Á¨Ó¥[Á`·í¤éª÷ÃB¥X¿ù

½Ð°Ý¦U¦ì¤j¤j
§Ú­n­pºâªºÄæ¦ì¬OBGÄæ¦ì
§PÂ_¬OAOÄæ¦ì
§Úªº­pºâ¦¡¦p¤U¡G
=SUMPRODUCT((AO3:AO39=TODAY())*BG46:BG82)
¦ý¬O§ÚAOÄæ¦ì¬O¥Î­pºâ¦¡Åã¥Ü¤é´Á
=IF(AS3="","",IF(AO3="",TEXT(TODAY(),"YYYY/mm/dd"),AO3))
¾É­PSUMPRODUCTµLªk§PÂ_¤é´Á
½Ð°Ý¤j¤j¦³¤èªk¶Ü
ÁÂÁÂ

¦^´_ 2# hcm19522

³ø§i¤j¤j
¤£¦æ
µ²ªG¬O0
¦]¬°§Úªº¤é´Á¤£¬O¤â°Ê¿é¤Jªº
¬O¤½¦¡
¾É­PSUMPRODUCTµLªk§PÂ_AOÄæ¦ì¤é´Á(¦]¬°¬O¤½¦¡)
½Ð°Ý¤j¤j¦³¸Ñ¤è¶Ü¡H
ÁÂÁ¤j¤j

TOP

¦^´_ 4# Andy2483


ÁÂÁ¤j¤j
¤ñ¸û»Ý­n¥i¥H¤£¥Î«ö¿z¿ï
ª½±µ¦Û°Ê§PÂ_ªº

TOP

¦^´_ 6# hcm19522

³ø§i¤j¤j
¥X²{#name?¿ù»~
ÁÂÁ¤j¤j

TOP

¥»©«³Ì«á¥Ñ coafort ©ó 2022-9-24 17:51 ½s¿è

¦^´_ 8# ­ã´£³¡ªL


ÁÂÁ¤j¤j
¥i¥H¥Î
¦ý¬O
¦pªGÄæ¦ì¬OªÅ¥Õ
·|¥X²{#VALUE¡I
¦]¬°§ÚBG46:BG82¬O¥Î=IF(AS41="","",...............
¦pªG§ï¬°=IF(AS41="",0,...............
¬O¥i¥H¸Ñ
¨º¦pªG­n«O¯d¥Î=IF(AS41="","",...............
¸Ó«ç»ò­×§ï©O¡H
·P®¦¤j¤j

TOP

¦^´_ 10# ­ã´£³¡ªL

«z~
ª©¤j¤j¯uªº¬O¯«¤H¤]
¤Ó±j¤j¤F
¯u¬O¤Ó¤Ó¤Ó·P®¦¤j¤j¤F:D

TOP

        ÀR«ä¦Û¦b : ¦n¨Æ­n´£±o°_¡A¬O«D­n©ñ±o¤U¡A¦¨´N§O¤H§Y¬O¦¨´N¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD