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

(¤w¸Ñ¨M)¦³¤ñSUMIF§ó¼F®`ªº¶Ü?

(¤w¸Ñ¨M)¦³¤ñSUMIF§ó¼F®`ªº¶Ü?

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:24 ½s¿è

SUMIF($A$6:$A$23,C29,$C$6:$C$23)
  ¦pªG§Ú­n¥[Á`±o¸ê®Æ¬O¥]§tDÄæ¥H«áªº¸ê®Æ(¦pSUMIF($A$6:$A$23,C29,$C$6:$C$23)+SUMIF($A$6:$A$23,C29,$D$6:$D$23) )
  ­n¥Î¤°»ò¤½¦¡?
  ¥t¥~¦pªG§ÚªºAÄæ¸ê®Æ¦pªG·|¼W¥[­n¥Î¤°»ò¤è¦¡?
  ¬O¤£¬O¥u¯à¥ÎVBA?

Doc1.rar (126.73 KB)

¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-9-20 22:35 ½s¿è

=SUM((A6:A23=$C$29)*(C6:C23+D6:D23))
°}¦C¤½¦¡

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-9-20 22:35 ½s¿è

£°..¦^ÂФ夤¥X²{·N¥~ªº¹Ï¥Ü.....¥[¤Wµ´¹ï°Ñ·Ó²Å¸¹¸Õ¸Õ¬Ý
=SUM(($A$6:$A$23=$C$29)*($C$6:$C$23+$D$6:$D$23))
°}¦C¤½¦¡

TOP

ÁV¿|..¶V§Ë¶VÁV..§ë­°¤F..·Ð½Ðª©¥D§R°£±¼³o´X½g¦^ÂЧa..

TOP

¦WºÙcol¬°2ªí¥Ü¹ïC¡BD¦C¶×Á`¡A¬°3ªí¥Ü¹ïC¡BD¡BE¦C¶×Á`¡K¡K
Book1.rar (1.45 KB)

¥H«á­nª½±µµoExcel®æ¦¡ªþ¥ó«¢¡C

TOP

¦^´_ 5# et5323


«¢ ¤U¦¸·|ªþÀÉ®×
¤j¤j¦^ÂЪºÀ³¸Ó¬O§Ú­nªº
¤£¹L¦³©w¸q¸Ì­±ªº¤½¦¡§Ú­n¦b¬ã¨s¨Ì¤U
¦³°ÝÃD·|¦A´£¥X
ÁÂÁ³á
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# toomellowhaw


    °}¦Cªº¤è¦¡§Ú¨S¦³«Ü²`¤J¬ã¨s
   ³o­Ó§Ú¤]·|¬ã¨s¨Ì¤U
   ÁÂÁ³á
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

=SUMPRODUCT((A6:A23=c29)*(C6:F23))

TOP

¦^´_ 8# ANGELA


­ì¨ÓSUMPRODUCT¥i¥H³o¼Ë¨Ï¥Î¡A¤½¦¡§ó²¼ä¡C
¼Wªø¨£»D¤F¡A·P®¦......

TOP

=SUMPRODUCT((A6:A23=c29)*(C6:F23))
ANGELA µoªí©ó 2010-9-21 09:58



    ¸Õ¤F¤@¤U¡Aµ²ªG«ç»ò¬O#value
°ÝÃD¥X¦b¨º¸Ì¡H

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD