ªð¦^¦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°_

¦^´_ 1# inhogold


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


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

TOP

¦^´_ 2# joblyc017

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

TOP

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

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD