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

[µo°Ý] ¥X¨®­pºâ

[µo°Ý] ¥X¨®­pºâ

¥X¨®®É¶¡A©Mªy¨®Àu´fB
½Ð°Ý¦p¦ó­pºâ¨º­Ó®É¶¡§t¦³ªy¨®®É¼Æªº¦¸¼Æ©O??
¥ÎSumif??
ÁÙ¬O­n·fOffset

¥¼©R¦W.jpg (72.9 KB)

¥¼©R¦W.jpg

HiuSang

¦³¤j¤j¥i¥H¸Ñµª¶Ü??
¤À®É¬q¦³¦h¤Ö­Ó1,2,3¤p®ÉÀu´f®É¼Æ
«ô°U
HiuSang

TOP

¸Ñ¨M¤F, ­n¥Î¦h¤@¦CLeft,¤§«á¥ÎCountif´N²³æ¦h¤F
HiuSang

TOP

¤½¥q¹q¸£¥Î2003, Countifs¤£¯à¥Î,¦³¨ä¥L¤èªk¶Ü??
HiuSang

TOP

¦^´_ 4# hiusang218


     §ï¥ÎSUMPRODUCT( )

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD