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

¦P¤@Äæ¦ì¨â­Ó¥H¤W¤£¦P¦WºÙ¦P¤@¶µ¥Ø­n°µ¥[Á`!

¦P¤@Äæ¦ì¨â­Ó¥H¤W¤£¦P¦WºÙ¦P¤@¶µ¥Ø­n°µ¥[Á`!

½Ð°Ý¦U¦ì°ª¤â
20190621.zip (7.15 KB) ¦³¤°³Â¼Ëªº¤½¦¡¥i²¤Æ¥Ø«e­pºâªº'¤è¦¡©O????
yvonne

=SUMPRODUCT(({"Ĭ¦{","ªF²ð"}=A2:A26)*C2:C26)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=SUM(SUMIF(A:A,{"Ĭ¦{","ªF²ð","¥xÆW¬ãµo"},C:C))

TOP

¦^´_ 3# ­ã´£³¡ªL


    ·PÁ²a¤j...*10000¡Aªøª¾ÃÑ...ÁÂÁÂ
yvonne

TOP

¦^´_ 2# hcm19522


    ·PÁÂH¤j~~ÁÂÁÂ*1000
yvonne

TOP

        ÀR«ä¦Û¦b : ¦³Ä@©ñ¦b¤ß¸Ì¡A¨S¦³¨­Åé¤O¦æ¡A¥¿¦p¯Ñ¥Ð¤£¼½ºØ¡A¬Ò¬OªÅ¹L¦]½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD