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

[µo°Ý] Ãö©ó¦Û°Ê¶ñ¼g¸ê®Æ°ÝÃD

[µo°Ý] Ãö©ó¦Û°Ê¶ñ¼g¸ê®Æ°ÝÃD

¥»©«³Ì«á¥Ñ tangandchun3 ©ó 2019-1-8 22:55 ½s¿è

¦U¦ì«e½ú¦n¡A¦³¤@¤u§@ºÃ°ÝÀµ½Ð¯à¨ó§Uµ¹¤©«Øij¡A¦p¹Ï¤ù©Ò¥Ü¡G




¥Î©ó¤@¨Ç­Ü®w°O¿ý,
©óM4,M9,M14,M18(¦p¦¹Ãþ±À)Ä椤,¦p¥XÃþ0¼Æ¦r,·|¦Û°Ê¦V¤W¶ñ¼g0,¦ÜM2,M5,M10,M15Äæ.
¦p¦³§ó¬°¤è«KEXCEL,¥i§_´£¨Ñ?
·PÁ¸U¤À
¼Æ­È.rar (39.9 KB)
GOOD BOY

­Y¬O¥u¦³0¤~¥N¤J0¡A¨º´N­n¦b¸Ì­±³]©w¤½¦¡¡A¨Ò¦p¡GM2¤º¤½¦¡¬O=IF(M4=0,M4,"")¡A¦]¬°±zªº¶¡¶Z¬O¤£¦Pªº¡A¥Ø«e¥u¦³·Q¨ì¥u¤@¤èªk
clio

TOP

M2/¤U©Ô
=IF(J2="TOTAL",SUM(H$1:H2)-SUM(I$1:I2)-SUM(M$1:M1),"")

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD