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

excel½d³ò²Î­p¤½¦¡°ÝÃD

excel½d³ò²Î­p¤½¦¡°ÝÃD

Â^¨ú.PNG
2018-9-30 21:55

½Ð°Ý¦p¦ó¥H¤½¦¡²Î­p¤W¤è¸ê®Æ½d³òªº«¬¸¹»P¼t°Ó¹ïÀ³ªºÁ`¼Æ¡H
´£¿ô¡G
1. ¸ê®Æ½d³òªº«¬¸¹·|¦³­«ÂСA¨Ò¦pA¦³3­Ó¡A©Ò¥H»Ý­nA«¬¸¹¥[Á`«áªºÁ`¼Æ
2. ¼t°Óªº¶¶§Ç¦ì¸m¨C¦¸³£¤£¤@©w¤@¼Ë¡A¨Ò¦p¦³®É­Ô¬OACGHBDIN¡A¦³®É­Ô¬OBCHIGNAD¡K¡K
¡@­ì¦]¬O¦]¬°¨t²Î¨C¤é¾É¥X¸ê®Æ¶¶§Ç·|²§°Ê¡A©Ò¥H«D©T©wÄæ¦ì¡C

¥H¤W¨D¸Ñ~~~~~~


½d¨ÒÀÉ.rar (7.79 KB)
*¦v¤k¤@ªTµL»~*

=SUMPRODUCT($C$4:$J$14*($B$4:$B$14=$B20)*($C$3:$J$3=C$19))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

=SUMIF($B$4:$B$14,$B32,OFFSET($B$4:$B$14,,MATCH(C$31,$C$3:$J$3,)))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# hcm19522

h¤j~·PÁÂÀ°¦£³á~~~


¦^´_ 3# ML089

M¤j~¤]«D±`·PÁÂÀ°¦£³á~~~




°ÝÃD¤w¸Ñ¨M¡A«D±`·PÁÂ2¦ì¤j¤j~~~~~
*¦v¤k¤@ªTµL»~*

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