ªð¦^¦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®¦~~

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

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

¦^´_ 1# inhogold


    ¥i¥H¥Î¼Ï¯Ã¤ÀªRªí¡A¸Ô¤U¹Ï¡G
2017-12-25_153806.png
2017-12-25 15:38


    ¨ç¼Æ¸Ñªk¡A¤½¦¡¸Ô¸Ñ¡A½Ð°Ñ¦Ò¡Ghttps://goo.gl/8fxk9k
E0140_1.png
2017-12-25 15:38

TOP

¦^´_ 2# joblyc017

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

TOP

=SUMIF(B:B,E2,C:C)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : §Ú­Ì³Ì¤jªº¼Ä¤H¤£¬O§O¤H¡D¥i¯à¬O¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD