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

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

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

¤j®a¦n, ¦³¨S¦³¤èªk¯à±Nªí¤@¦X±ø¥óªº¤é¤l¶Ç¦^ªí¤G, ÁÂÁÂ

rainfall.rar (7.57 KB)

«B¤ôªí

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

TOP

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

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

TOP

¥»©«³Ì«á¥Ñ 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

¦¨¥\¤F,ÁÂÁÂ
¦ýÁÙ¦³¤@­Ó²×·¥°ÝÃD«Ý¦U¦ì¤j¤j¸Ñµª, ´N¬O¯à§_±Nªí¤Gªº¸ê®Æ¦©°£¤F°²¤é¤Î¬P´Á¤Ñ«á¦^¶Ç¦Üªí¤T©O?

rainfall3.rar (10.71 KB)

ªí¤T

TOP

¦^´_ 7# p212


    ¦Ü©ó²Å¦XRainfall > 20mm±ø¥ó¤§¡u°²´Á¡v­pºâÄÝ¡u¦h¹ï¦h¡v¡A
>> Àx¦s®æ B63=SUMPRODUCT(COUNTIF(B$43:B$62,$L$43:$L$59))
¤£ª¾¬O§_¬O³o¼Ëªº»Ý¨D¶Ü?

TOP

ÁÂÁÂp212¥Sªº«ü±Ð,¤p§Ì¤w¸gÀò¯q¨}¦h¤F

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-9 09:18 ½s¿è

¦^´_ 6# ffff56666
1¡B¦^¶Ç²Å¦XRainfall > 20mmÁ`¤Ñ¼Æ(²Ä65¦C)»PRainfall > 20mm¤§¬P´Á¤éÁ`¤Ñ¼Æ(²Ä64¦C)¡G
Àx¦s®æB64=SUMPRODUCT((TEXT(B43:B62,"aaa")="¶g¤é")*1)
Àx¦s®æB65=COUNTIF(B$8:B$38,">20")
¦V¥k½Æ»s¡A½Ð°Ñ¦Ò¡I
2¡B¦Ü©ó²Å¦XRainfall > 20mm±ø¥ó¤§¡u°²´Á¡v­pºâÄÝ¡u¦h¹ï¦h¡v¡A¥»¤H¼ÈµL¸Ñ¡A¦³½Ðª©¥D¡B¶Wª©«ü±Ð¡AÁÂÁ¡I

TOP

¦¨¥\¤F, ¦hÁÂÀ°¦£!
·Q°Ý°Ý¯à§_¦b¤U«B¤Ñ·í¤¤¦Û°Ê¶Ç¦^¦h¤Ö¤Ñ¬O¬P´Á¤Ñ, ¤Î¦h¤Ö¤Ñ¬O°²´Á©O, ÁÂÁÂ

rainfall2.rar (9.64 KB)

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2014-7-8 16:15 ½s¿è

¦^´_ 4# ffff56666
1¡Bfor Excel 2007: Àx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IFERROR(DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))),"")
µù¡G±zªº³nÅ骩¥»¤£¬O¼Ð¥ÜOffice 2007¡H
2¡Bfor Excel 2003: Àx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IF(ISERROR(DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1)))),"",DATE(B$6,B$7,SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))))

Àx¦s®æB43®æ¦¡¤§¡u¼Æ­È¡v½Ð³]¬°¡u¤é´Á¡v¡A¦V¥k¡B¦V¤U½Æ»s¡C
½Ð°Ñ¦Ò¡I

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD