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

[µo°Ý] ³o­Ó¬°¤°»ò¨S¿ìªk¨Ï¥Îsumif¿z¿ï¥[Á`©O ?¨D¸Ñ

[µo°Ý] ³o­Ó¬°¤°»ò¨S¿ìªk¨Ï¥Îsumif¿z¿ï¥[Á`©O ?¨D¸Ñ

¨D¸Ñ
¦p¹Ï


µLªk¨Ï¥Îsumif¥[Á`.rar (4.15 KB)

¦^´_ 6# ANGELA


§Ú¤@ª½³£¥H¬°¥i¥HÀH·N«ü©w½d³ò¡AµM«á¥u­n½d³ò¤¤¦³²Å¦Xªº±ø¥ó¡A´N¥i¥H§ä¥X¬Û¹ïÀ³ªºµª®×¡A
­ì¨ÓÁÙ¦³¬Û¹ïÀ³ªºÃöÁp¡AÅ¥§A­ÌÁ¿¸Ñ¹L«á¡A¤~ª¾¹D¥¿½T­ì¦]¡A¨ü±Ð¤F¡I

TOP

¶Q¦¡¿ù»~±¡ªp¬°
=SUMIF($A$3E$92,H3,$E$3)

A3¡BB3¡BC3¡BD3¡BE3 »PH3¤ñ¸û¡A¦^¶Ç¹ïÀ³ E3¡BF3¡B G3¡B H3¡B I3 ­È
¨ä¹ê§Aªº¥Ø¼Ð¬O­n¤ñ¹ïC¦^¶ÇE¡A¥Ñ¤Wªº¹ïÀ³¦^¶Çªº¬OG¡AGÄæ­n¬OªÅ¥ÕÄæ©Ò¥H¬O0
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

=SUMIF(C:C,H3,E:E)
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# owen06


    =SUMIF($B$3:$E$91,H3,$E$3)
    ¦bBÄæ§ä¨ìH3¬Û¦P­È·|¶Ç¦^EÄæ¬Û¦P¦ì¸mªº­È¥h¦X­p
      ¦bCÄæ§ä¨ìH3¬Û¦P­È·|¶Ç¦^FÄæ¬Û¦P¦ì¸mªº­È¥h¦X­p
      =SUMIF($B$3:$E$91,H3,$E$3)
    ¬O¬Ù²¤¼gªk=SUMIF($B$3:$E$91,H3,$E$3:$H$91)

TOP

§ÚÁÙ¦³¤@­Ó°ÝÃD¡A§Ú¨Ï¥Î¶i¶¥¿z¿ï ¡A¤£­«½Æ¿z¿ï¡C¦ý¬O¸Ì­±«çÁÙ¬O·|¦³­«½Æªº?

TOP

¦^´_ 3# keovin790916

§A§â¥L§ï¦¨³o¼Ë´N¦æ¤F
=SUMIF($C$3:$E$91,H3,$E$3:$E$91)


¦Ü©ó¬°¤°»òb3:e91¤£¦æ¡A§ï¦¨c3«á´N¥i¥H¤F¡A
§Ú¤]¤£À´@@¡A¥i¯à­n½Ð°ª¤â¨ÓÁ¿¸Ñ¤F¡C

TOP

p212¤j¤j

§Ú­nªºµª®×¬O«ö³y¥N¸¹§â¹ê¥Iª÷ÃB²Ö­p°_¨Ó¡A¨ä¥Lªº¤è¦¡§Ú¥ÎSUMIF³£¥i¥H«ü©w¥[Á`¡A¤£ª¾¹D¬°¤°»ò³o­Ó¨S¿ìªk«ü©w¥[Á`!!!  ¨D¸Ñ

TOP

¦^´_ 1# keovin790916
1¡B½Ð°Ý±z­nªºµª®×¬O¤°»ò?
2¡B¦p±z¦bI2Àx¦s®æªº¤½¦¡
=SUMIF($B$3:$E$91,H3,$E$2)
$E$2¬OµLªk·í§@sum_rangeªº
¥i§_¸Ô­z¤@¤U±zªº°ÝÃD?ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD