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

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

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



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

TOP

¦^´_ 8# ANGELA


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

TOP

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

TOP

¦^´_ 3# toomellowhaw


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

TOP

¦^´_ 5# et5323


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

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

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

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

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

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

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD