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

¡i½Ð±Ð¡j¦p¦ó­pºâ¨C­Ó¤H·í¤ë¤£¦P¯Z§OªºÁ`®É¼Æ©M?

¡i½Ð±Ð¡j¦p¦ó­pºâ¨C­Ó¤H·í¤ë¤£¦P¯Z§OªºÁ`®É¼Æ©M?

¨C­Ó¯Z§O®É¼Æ³£¤£¬Û¦P¡A¨C­Ó¤H¨C¤ë³£»Ý­n¤W¤£¦P¯Z§O
»Ý±±ºÞÁ`®É¼Æ¤£¶W®É¡A¦p¦ó­pºâ¨C­Ó¤H·í¤ë¤£¦P¯Z§OªºÁ`®É¼Æ©M¦bAHÄæÀx¦s®æ¤º§e²{
ªþ¤W¯Z§Oªí
­Y¥i¥H½Ð¨ó§U
«D±`·PÁÂ~~^__^

¯Z§O(­pºâÁ`®É¼Æ).rar (17.06 KB)

¯Z§O

mmap

¦^´_ 1# mmap

AH4
=SUMPRODUCT(SUMIF(¯Z§O!$A:$A,'09'!$C4:$AF4,¯Z§O!$B:$B))
¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# mmap

AH4
=SUMPRODUCT((C4:AG4=¯Z§O!A$2:A$33)*¯Z§O!B$2:B$33)
¤U©Ô
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

«D±`·PÁÂ~~
¦³¤£¦Pªº§@ªk³£¥i¥H±o¨ì·Q­nªºµ²ªG~~
¨ü±Ð¤F~~^^
mmap

TOP

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD