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

­p¦¸ªº°ÝÃD

­p¦¸ªº°ÝÃD

test.rar (4.1 KB)
½Ð°Ý¦U¦ì¥ý¶i
§Ú¦p¦ó¦bªþ¥ó¤¤ªºÁ`¼Æ­p¦¸¥ªÃ䪺¬ì§O
¨Ã¦bDNRñ¸pÄæ¦ì­pºâ¤d¸p¦¸¼Æ

¨Ò¦p: ¤@¯ë¥~¬ì¦b·|¶E¬ì§O¤@¦@¥X²{´X¦¸,·|­p¦¸¦b¤@¯ë¥~¬ìªºÁ`­p
         ¥BDNR¦@´X¦¸°O¿ý¦bDNRñ¸pÄæ¦ì

·PÁ¦U¦ì¥ý¶iªº«ü¾É

¦^´_ 1# louischen1104


G2Àx¦s®æ
=COUNTIF($A$2:$A$12,F2)
H2Àx¦s®æ
=SUMPRODUCT(($A$2:$A$12=F2)*$C$2:$C$12)

TOP

¦^´_ 2# pesi2884


¥ý¨Ó¸Õ¸Õ¬Ý, ·PÁÂ!!

TOP

pesi2884¤j¤j, °ÝÃD¤w¸Ñ¨M
¦ý¤p§Ì¤£À´H2±o¼gªk
SUMPRODUCT¬O¹ïÀ³¤¸¯À­¼¿n¤§©M,
¥L¦p¦óºâ¥XDNR¦b¦P¬ì§O¤º¥X²{1ªº¦¸¼Æ©O?

TOP

¦^´_ 4# louischen1104


    =SUMPRODUCT(($A$2:$A$12=F2)*$C$2:$C$12)
©î¸Ñ¤j·§·N«ä¬°
   (A2=F2)*C2     A2=F2¦pªG¬°TURE´N¥Nªí1¦pªG¬°False´N¥Nªí0
+(A3=F3)*C3     A3=F3¦pªG¬°TURE´N¥Nªí1¦pªG¬°False´N¥Nªí0
...
+(A12=F12)*C12     A12=F12¦pªG¬°TURE´N¥Nªí1¦pªG¬°False´N¥Nªí0

TOP

ÁA¸Ñ¤F!! ·PÁÂP¤j!

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD