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

[µo°Ý] excel ¦p¦ó§PÂ_¤£¬Û¾FÀx¦s®æ¤£¬°0

[µo°Ý] excel ¦p¦ó§PÂ_¤£¬Û¾FÀx¦s®æ¤£¬°0

·Q½Ð°Ý Á`¦¨ÁZ¤½¦¡ ±N"¦¨ÁZ"ªºÄæ¦ì¥[Á`°£¦A­¼4
¦p¦ó±Æ°£GÄ檺¤À¼Æ
¦pªþ¹Ï


¤w§xÂZ¤w¤[ :'(
³Â·Ð°ª¤â¸Ñ´b

¦^´_ 1# somn

°Ñ¦Ò¬Ý¬Ý
  1. =4*SUMPRODUCT((F4:J4<>0)*(F3:J3="¦¨ÁZ")*F4:J4)/SUMPRODUCT((F4:J4<>0)*(F3:J3="¦¨ÁZ"))
½Æ»s¥N½X

TOP

¦^´_ 2# naruto018
·PÁÂN¤j
¦ý®M¥Î¨ì§Úªºªí·|¥X²{#VALUE
¤£¦n·N«ä ·Q½Ð°Ý¬O§_§Ú§PÂ_ªºÄæ¦ì¦³»~

TOP

¦^´_ 3# somn


    ¨º¬O¦]¬°I5:U5¤¤¦³¤å¦r
¤½¦¡­n§ï¦¨
  1. =4*SUMPRODUCT(I5:U5,(I5:U5<>0)*($I$4:$U$4="¦¨ÁZ"))/SUMPRODUCT((I5:U5<>0)*($I$4:$U$4="¦¨ÁZ"))
½Æ»s¥N½X

TOP

¦^´_ 4# naruto018

wow~~~~«D±`·PÁÂN¤j

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD