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

[µo°Ý] ¥i§_¨Ì¦WºÙ¦b¥¨¶q¸ê®Æ¤º²Î­p¥LªºÁ`¦¸¼Æ

[µo°Ý] ¥i§_¨Ì¦WºÙ¦b¥¨¶q¸ê®Æ¤º²Î­p¥LªºÁ`¦¸¼Æ

½Ð°Ý¦U°Ý¤j¤j­Ì?
¥i§_¨Ì¦WºÙ¦b¥¨¶q¸ê®Æ¤º²Î­p¥LªºÁ`¦¸¼Æ?
§Ú´¿·Q¹L¥ý¥ÎCOUNTIF¥ý²Î­p¥X³o­Ó¤Hªº¥X²{¦¸¼Æ¡AµM«á¦A¥h²Î­p¥X¥LÁ`¨Ï¥Î¦¸¼Æ¡C
¥i¬O¸ê®Æ¤H¦W¹ê¦b¤Ó¦h¤F¡A¦³§ó®e©öªº¨ç¼Æ¨Ó²Î­p¶Ü??
·P®¦~~

111.png (37.33 KB)

¨Ì¦WºÙ²Î­p¦¸¼Æ

111.png

¸U¤V°ª¼Ó¥­¦a°_

=SUMIF(B:B,E2,C:C)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# joblyc017

ÁÂÁÂjoblyc017!!·PÁ±z!!try¥X¨Ó¤F
¦A¦¸·PÁÂ
¸U¤V°ª¼Ó¥­¦a°_

TOP

¦^´_ 1# inhogold


    ¥i¥H¥Î¼Ï¯Ã¤ÀªRªí¡A¸Ô¤U¹Ï¡G


    ¨ç¼Æ¸Ñªk¡A¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/8fxk9k

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD