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

[µo°Ý] ¦p¦ó¤ÀÃþ¨Ã¤À§O²Î­p¸ê®Æ?

H2 ¤U©Ô=SUMPRODUCT((B$2:D$9=G2)*(A$2:A$9=LOOKUP(1,0/(F$2:F2<>""),F$2:F2)))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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