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

[µo°Ý] ¨ç¼Æ_°ÊºA°Ñ·Óªº°ÝÃD

[µo°Ý] ¨ç¼Æ_°ÊºA°Ñ·Óªº°ÝÃD

ªþ¥ó¡G ¨ç¼Æ_°ÊºA°Ñ·Óªº°ÝÃD.rar (16.93 KB)
·íH4¡GHn¦³¼Æ­ÈªºÀx¦s®æ­Ó¼Æ¬O¬°°ÊºA®É¡A
­ì·Q¥H²{¦³ªº¤½¦¡(½Ð¨£AJ1¤½¦¡)¦A¥[¤JINDIRECT¨ç¼Æ½s¼g(½Ð¨£AI1¤½¦¡)¡A
¦ýINDIRECT·|±N­pºâ¦ì§}©T©w¦bAIÄæ¡A¾É­PAI1¦A©¹¥k©Ôªº¤½¦¡µL®Ä¡C

½Ð°Ý¡GAI1¥i°ÊºA°Ñ·Óªº¤½¦¡­n¦p¦ó­«·s½s¼g¡H
ÁÂÁ¡I

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2022-1-7 19:06 ½s¿è

AI1 ¥k©Ô (¤½¦¡ ¤â°Ê§ï¦Û°Ê)=IF(AI2="","",SUMPRODUCT(OFFSET($AH4,,,COUNT($AH:$AH))*OFFSET(AI4,,,COUNT($AH:$AH))))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
hcm19522¤j¤j :±z¦n!
´ú¸ÕOK¤F
ÁÂÁ±zªº¼ö¤ßÀ°¦£©M«ü¾É~·P®¦

¤£¦n·N«ä¡A¤U¦C°ÝÃD¯à§_½Ð±z¦AÀ°¦£¤@¤U~
http://forum.twbts.com/thread-23556-1-1.html
ÁÂÁ±z

TOP

¥»ÃDÅÜ°Ê®æ¼Æ³]©w³Ì¦h¨ì999¦æ=IF(AI2="","",SUMPRODUCT((0&$AH4:$AH999)*AI4:AI999))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 4# hcm19522
±z¯u¬O°ª¤â
ÁÂÁ±zªº­@¤ß«ü¾É~·P®¦

TOP

¦^´_ 4# hcm19522
ªþ¥ó :   ¨ç¼Æ_¹ïÀ³¼Æ¦rªº­Ó¼Æ²Î­p_0109.rar (27.13 KB)
hcm19522¤j¤j :±z¦n!
¤£¦n·N«ä¡A¦]¬°AI4:BU42¦³¤½¦¡­È=""¡A¾É­PAI1:BU1ªº¤½¦¡­È³£=#VALUE!
¸Ô¦pªþ¥ó : ´ú¸Õª©!

½Ð°Ý : AI1ªº¤½¦¡­n¦p¦ó­×¥¿ ?
ÁÂÁ±z !

TOP

=IF(AI2="","",SUMPRODUCT((0&$AH4:$AH42)*(0&AI4:AI42)))
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 7# hcm19522
ÁÂÁ±zªº­@¤ß«ü¾É~·P®¦:handshake

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD