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

[µo°Ý] ¦p¦ó¶Ç¦^¦X±ø¥óªº¤é¤l

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-10 21:51 ½s¿è

¦^´_ 10# ffff56666
²Å¦XDate of Rainfall > 20mm¥B±Æ°£°²¤é¤Î¬P´Á¤Ñ®É¡A¨Ï¥Î =COUNTIF(B$8:B$38,">20")-SUMPRODUCT(COUNTIF(B$43:B$62,$L$43:$L$59))-SUMPRODUCT((TEXT(B43:B62,"aaa")="¶g¤é")*1) ¥i¥H¡H
ÁÙ¬O­n§óµuªº¤½¦¡¡H

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-10 21:49 ½s¿è

¦^´_ 9# samwang
没·Q¨ì³o»ò²³æ¡ISUMPRODUCT¡ÏCOUNTIF
ÁÂÁÂsamwang ¤jªº¸Ñ´b

TOP

¦A¤@¦¸¦hÁÂp¤jªº¸Ñµª, §Aªº¤½¦¡À³¬O­pºâ¦X±ø¥óªº¤é¤lÁ`¼Æ, ¦ý¦pªG¦Û°Ê±N¦X±ø¥óªº¤U«B¤é´Á¥Ñªí¤G¤¤¥Î¤½¦¡¿z¿ï¨ìªí¤Tªº¸Ü¬O§_¯à°µ¨ìªº©O?
ÁÂÁÂ

TOP

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD