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

[µo°Ý] ¥|±Ë¤­¤J¨ú¾ã¼ÆªºÁ`©M...

[µo°Ý] ¥|±Ë¤­¤J¨ú¾ã¼ÆªºÁ`©M...

¥|±Ë¤­¤J¨ú¾ã¼ÆªºÁ`©M...
L2:L19Àx¦s®æ§t¦³¤½¦¡
L20¦X­pÀx¦s®æ{=SUM(ROUND(L2:L19,))}
¦]L2-L8¡BL16-L17Àx¦s®æµL±a¤J¼Æ­È ("")
³y¦¨L20Àx¦s®æµLªk¦X­p L2:L19Àx¦s®æ¥|±Ë¤­¤J¨ú¾ã¼ÆªºÁ`©M!!
¸Ó¦p¦ó­×¥¿¤½¦¡?

1100119.rar (8.08 KB)

¦^´_ 3# hcm19522

¤ô°Õ!!·P®¦  ^^
°w¹ï©Ò­z°ÝÃD¥Hªï¤b¦Ó¸Ñ
°w¹ï¦³¤½¦¡ªºÀx¦s®æµL¼Æ¾Ú®É...""
¥i§Q¥Î
=SUMPRODUCT(ROUND((0&¿ï¾Ü½d³ò)*1,))
¬A©·¤ºªº 0& ¤Î *1 ¬O­«ÂI©Ò¦b

TOP

=SUMPRODUCT(ROUND((0&L2:L19)*1,))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 1# cypd

§A¦n
§A¥i¥HÂI¶iÀÉ®×>¿ï¶µ>¶i¶¥>§ä­pºâ¦¹¬¡­¶Ã¯®É>¤wÅã¥Ü­È¬°·Ç>¥´¤Ä
¬O§_¥i¥H
ÁÂÁÂ
±Ó¦Ó¦n¾Ç,¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : Ä@­n¤j¡B§Ó­n°í¡B®ð­n¬X¡B¤ß­n²Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD