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

[µo°Ý] ½Ð°Ý¦p¦ó±N¸ê®Æ¶i¦æºI¨ú«á¡A¦A¬Û¥[©O?

[µo°Ý] ½Ð°Ý¦p¦ó±N¸ê®Æ¶i¦æºI¨ú«á¡A¦A¬Û¥[©O?

¤j®a¦n¡A

·Q½Ð±Ð¦p¦ó±N¸ê®Æ¥ý¶i¦æºI¨ú«á¡A¦A¬Û¥[©O? »¡©ú¦p¤U¡G



¥ÑE4¶}©l©¹¤U¬O¸ê®Æ¡A§Æ±æ±N³o¨Ç¸ê®Æ¶i¦æ³B²z¡G
E4¡G3~10  ¡A ¬Û´î¬O7
E5¡G¬O0
E6¡G10~24¡A¬Û´î¬O14
E7¡G¬O7
Æبä¾lÃþ±À

§Æ±æ±NE4¶}©l©¹¤Uªº­È³£¬Û¥[¡G7+0+14+7+0+13+6=47¶ñ¦bE1 (¦ÓE1ªº¤½¦¡¸Ó¦p¦ó¤U©O?)
¸ê®Æ¤£¥u¦³7µ§¡A¦ý¬°¤F¤è«K¡A¶È¦C¥X7µ§¡C

³Ì«áªþ¤Wªþ¥óÀÉ¡G ¬¡­¶Ã¯1.zip (6.95 KB)

·Q½Ð¤j®a¨ó§U´£¨Ñ·Qªk¡AÁÂÁ±z­Ì¡C

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2023-11-30 10:48 ½s¿è

(¿é¤J½s¸¹12079) googleºô§}:https://hcm19522.blogspot.com/
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¥»©«³Ì«á¥Ñ gaishutsusuru ©ó 2021-8-1 18:22 ½s¿è

¦^´_ 2# hcm19522


¦n¼F®`!
ÁÂÁÂhcm¤j¤jªº¨ó§U¡A¤½¦¡¥i¥H¥Î!

¤£¹L·Q¦A½Ð±Ð±z¡A¦P¼Ëªº¤½¦¡¡A©ñ¦bgoogle ¸Õºâªí°õ¦æ®É¡A·|Åã¥Ü¡G¨t²Î­pºâ¡uTEXT¡v®Éµo²{¡u0;-0;0;!0¡v®æ¦¡µL®Ä

½Ð°Ý¸Ó¦p¦ó¸Ñ¨M³o­Ó°ÝÃD©O? ÁÂÁ±z

TOP

=SUM(MMULT(--LEFT(RIGHT(SUBSTITUTE("0~"&E4:E10,"~",REPT(" ",9)),{18,9}),9),{-1;1}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


  ÁÂÁ±zªº¨ó§U¡A¦ý¦n¹³­Y½d³ò§ï¦¨E4:E20¡A«h·|¥X²{¿ù»~¡C(¦ü¥G¬O¦]¬°¦pªGÀx¦s®æ¬OªÅ¥Õ®É¡A·|¤£¯à°õ¦æ)

½Ð°Ý¸Ó¦p¦ó³B²z©O? ÁÂÁ±z¡C

TOP

¦^´_ 5# gaishutsusuru


    =SUM(MMULT(-LEFT(RIGHT(SUBSTITUTE(REPT(0,30)&E4:E20,"~",REPT(" ",15)),{30,15}),15),{1;-1}))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 6# ML089


­ì¨Ó¦p¦¹¡AÁÂÁ±zªºÀ°¦£¡A¤½¦¡¥i¥H¥Î!!

TOP

¦^´_ 3# gaishutsusuru


    {=SUM(IFERROR(LEFT(RIGHT(SUBSTITUTE("~"&B4:B99,"~",REPT(" ",9)),{18,9}),9)*{-1,1},))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

­Y¬O­pºâ½c¼Æ,
3~10 ... À³¸Ó¬O8½c

TOP

°}¦C
=SUM(ABS(INT(SUBSTITUTE(0&E4:E19,"~","."))-(0&MID(E4:E19,FIND("~",E4:E19&"~")+1,9))))

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD