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

[µo°Ý] ¦p¦ó¤ñ¹ï²Å¦X¸ê®Æ¨Ã¥[Á`¹ïÀ³ªº¼Æ­È

[µo°Ý] ¦p¦ó¤ñ¹ï²Å¦X¸ê®Æ¨Ã¥[Á`¹ïÀ³ªº¼Æ­È

­n½Ð±Ð¦U¦ì«e½ú,
¦p¹Ï,¦p¦ó§Q¥Î¤½¦¡§ì¨ì¤W¤è¨âµ§Kevin Liªº¹ïÀ³¸ê®Æ9+2ªº¼Æ¾Ú!!

ÁÂÁÂ
Maggie

©êºp,¦b¦¹¸É¤WExcelÀɮרѦU¦ì¨Ï¥Î,
¦ýê©óÅv­­,½Ð¦^ÂЪºªB¤Í,¦n¤ß±N¨ç¼Æ¶K¥X´£¨Ñ°Ñ¦Ò,«D±`·PÁÂ!!
Excel inquire.zip (6.42 KB)

TOP

¦^´_ 2# amaggie_h

AA44=SUMIF(B$3:$B$42,B44,$AA$3:$AA$42)¦V¤U½Æ»s
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

Dear Hsieh ^^
I really appreciate it, The answer is great help for me !!
­ì¨ÓSUMIF¥i¥H³o¼Ë¨Ï¥Î,§ÚÁÙ·Q¯}ÀY¤@ª½¥Î¨ì¦³Ãö"°Ñ·Ó"ªº¨ç¼Æ=_=
Maggie

TOP

        ÀR«ä¦Û¦b : ¥ÌÄ@°µ¡BÅw³ß¨ü¡C
ªð¦^¦Cªí ¤W¤@¥DÃD