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

[µo°Ý] EXCEL ¦p¦ó¿z¿ï§Ú­nªº¸ê®Æ"¦p¹Ï" ¨D°ª¤â¸Ñ

[µo°Ý] EXCEL ¦p¦ó¿z¿ï§Ú­nªº¸ê®Æ"¦p¹Ï" ¨D°ª¤â¸Ñ

EXCEL ¦p¦ó¿z¿ï§Ú­nªº¸ê®Æ"¦p¹Ï" ¨D°ª¤â¸Ñ

¦p¹Ï¨º



¨D§U.rar (2.21 KB)

=SUMIF($E$2:$E$15,E19,Q$2)

TOP

¦^´_ 2# ANGELA


   

¦pªG§Ú­n§¤¦b ¤u§@­¶2ªº¸Ü ­n«ç»ò¥Î?

TOP

=SUMIF(Sheet1!$E$2:$E$15,E19,Sheet1!Q$2)

TOP

¦^´_ 4# ANGELA


    ¬°¤°»ò§Ú¿z¿ï«á¡A·|¥X²{¸ò¤u§@¤@ ¥[°_¨Ó¤£¤@¼Ë¡C

·Ó§Aªº¤è¦¡¥´¡C

TOP

§Ú­n°Ý¡A
=SUMIF(Sheet1!$C$2C$999,A19,Sheet1!O$2)   §Ú·Ó³o¤è¦¡¥´

¦ý¬O¦³¨Ç¼Æ­È¬O·j´M¨ì¿ù»~ªº¼Æ­È¡C

TOP

¦^´_ 6# keovin790916

   =SUMIF(Sheet1!$C$2:C$999,A19,Sheet1!O$2)
   ­º¥ý½T»{¥N¸¹¬O¦bE2:E999ÁÙ¬O¦bC2:C999
   ¦A¨ÓSHEETS2ªºÀx¦s®æA19¬O§_¦³¿é¤J3250©Î3556µ¥
     A19«e­±¤£¥[¤u§@ªí¦WºÙ,´Nªí¥Ü·í«e¤u§@ªí.

TOP

¦^´_  ANGELA


    ¬°¤°»ò§Ú¿z¿ï«á¡A·|¥X²{¸ò¤u§@¤@ ¥[°_¨Ó¤£¤@¼Ë¡C

·Ó§Aªº¤è¦¡¥´¡C
keovin790916 µoªí©ó 2012-12-28 08:02


½Ð°Ñ¦Ò³oÀɮתº G9:G21 °Ï°ì

¨D§U.rar (2.82 KB)

300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD