p212

¦^´_ 1# ffff56666
²Å¦XDate of Rainfall > 20mm¥B±Æ°£Àx¦s®æ¤º®e¬°¡uTrace¡v»P¡u-¡v¤§±ø¥ó¡AÀx¦s®æB43¿é¤J°}¦C¤½¦¡ (Ctrl+Shift+Enter)
=IFERROR(SMALL(IF((B$8:B$38>20)*(ISNUMBER(B$8:B$38)),$A$8:$A$38,FALSE),ROW(1:1))&"/"&B$7,"")
¦V¥k¡B¦V¤U½Æ»s
½Ð°Ñ¦Ò¡I

p212

¦^´_ 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

p212

¦^´_ 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

p212

¦^´_ 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

p212

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