ªð¦^¦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 : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD