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

[µo°Ý] ¥[Á`ªº¤½¦¡

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-9-21 11:43 ½s¿è

¦^´_ 1# PJChen


    aa3=SUMPRODUCT(($B$4:$B$18=$B4)*($C$3:$Z$3=AA$3),$C$4:$Z$18)
    ab3=SUMPRODUCT(($B$4:$B$18=$B4)*($C$3:$Z$3=AB$3),$C$4:$Z$18)
    ¬O­n³o¦U¶Ü

   ¥Î¤@¯ëªº+©ÎªÌsum¤]¥i¥H¹F¨ì ¥u¬O­nÂI«Ü¦h­Ó
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 5# PJChen

   ³o¸ÌÀ³¸Ó¨Ï¥Î ML089ªº¤½¦¡
  ¦]¬°§A¬O­n¥[Á`¸Ó¦Cªº¸ê®Æ
  ¦pªG¦³¨â¦U«È¤á¬Û¦P¥i¯à´N·|­«ÂЭpºâ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD