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

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

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

½Ð±Ð¦U¦ì¤j¤j,

¼Æ¶q¤Îª÷ÃB¦b¦P¤@¦C¤¤®É,¦p¦óÅýAA/ABÄæ¦U§O±N¼Æ¶q¤Îª÷ÃB¥[Á`?
P.S. ¤½¦¡­n¥i¥H¤U©Ô,ÁקK¦]¬°­Ó§OKey¤½¦¡,¤@¤£¤p¤ß³y¦¨¿ù»~.

«È¤á§O_¥[Á`.zip (13.69 KB)

¥»©«³Ì«á¥Ñ 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

¦^´_ 1# PJChen

AA4¤½¦¡
=SUMPRODUCT($C4:$Z4*($C$3:$Z$3=AA$3))
©¹¥k½Æ»s
¿ïAA4¡BAB4©¹¤U½Æ»s¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# freeffly

­ì¨Ó¤½¦¡ÁÙ¯à³o»ò¨Ï¥Î,ÁÂÁ±z!

TOP

¦^´_ 3# ML089

ÁÂÁ±z´£¨Ñªº¤½¦¡,ok!

TOP

¦^´_ 5# PJChen

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

TOP

¦^´_ 6# freeffly
±z»¡±o¨S¿ù,¦hÁ´£¿ô!

TOP

¦^´_  PJChen

AA4¤½¦¡
=SUMPRODUCT($C4:Z4*($C$3:Z$3=AA$3))
©¹¥k½Æ»s
¿ïAA4¡BAB4©¹¤U½Æ»s¤½¦¡
ML089 µoªí©ó 2012-9-21 19:56


©ÎªÌ

=SUMIF($C$3:$Z$3,AA$3,$C4)

TOP

¦^´_ 8# JBY
ÁÂÁ±z,

AA4=SUMPRODUCT($C4:Z4*($C$3:Z$3=AA$3))  ....3F¤]¦³´£¨ì

¥t¥~AA4=SUMIF($C$3:$Z$3,AA$3,$C4)....À³¸Ó§ï¬°: AA4=SUMIF($C$3:$Z$3,AA$3,$C4:$Z4) ¤~¥¿½T®@!

TOP

¦^´_ 9# PJChen


    =SUMIF($C$3:$Z$3,AA$3,$C4)
       ­pºâ³æ¤¸®æ¡A¥u­n«ü¥X°_©lªº³æ¤¸®æ§Yº¡¨¬SUMIFªº±ø¥ó¡A¤£¤@©w­n«ü¥Xµ²§ôªº³æ¤¸®æ¡C
       ¤½¦¡¼ôªº¤H±`·|¬Ù¥h¤@¨Ç°Ñ¼Æ¡A¦p,0  ,""·|¥u¼g,

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD