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

[µo°Ý] ¦P®É²Å¦X¨â­Ó±ø¥óªº¨ç¼Æ

[µo°Ý] ¦P®É²Å¦X¨â­Ó±ø¥óªº¨ç¼Æ

½Ð±Ð¦U¦ì«e½ú¥H¤Uªº°ÝÃD¡G

§Ú­ì¥»³]©w¨ç¼Æ¬°¡GCOUNTIF($L$3:$L$114,"¤j¾Ç")¡Ð¡Ð¡Ð¥i¥H²Î­p¥X¾Ç¾ú¬°¤j¾ÇªÌ¦³´X¦ì¡H
¡@¡@¡@¡@¡@¡@¡@¡@¡@COUNTIF(J3:J114,"¤k")¡Ð¡Ð¡Ð¥i¥H²Î­p¥X©Ê§O¬°¤k©ÊªÌ¦³´X¦ì¡H
¡@¡@¡@¡@¡@¡@¡@¡@¡@¦ý¬O²{¦b­n¦P®É²Å¦X¥H¤W¨â¶µ¿z¿ï±ø¥ó¡A¥ç§Y¤k©Ê¤j¾Ç¾Ç¾úªÌ¦³´X¦ì¡H½Ð°Ý¸Ó¦p¦ó³]©w¨ç¼Æ©O¡H


·PÁ«ü±Ð¡I

¦^´_ 1# onegirl0204
=SUMPRODUCT(($J$3:$J$114="¤k")*($L$3:$L$114="¤j¾Ç"))
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 2# p212

¸g¹L´ú¸Õ¡ã¸ê®Æ¥¿½T¡A·PÁ±zªº«ü±Ð¡I

TOP

¦^´_ 2# p212

¯Â¤å¦r¨S°ÝÃD¡A¦ý¬O¹J¤W¤ñ¸û¼Æ¦rªº¤½¦¡¦ü¥GµLªk®M¥Î­C¡I

   ¡@¥¼º¡¢°¢±·³ªº¤H¼Æ¡]¨k¤k¤H¼Æ¦X­p¡A¨Ã¥¼¯S¦a°Ï¤À¨k¤k¡^¡Ð¡Ð¡Ð COUNTIF($AB$3:$AB$114,"<12")
¡@¢°¢±¡ã¢°¢¶·³ªº¤H¼Æ¡]¨k¤k¤H¼Æ¦X­p¡A¨Ã¥¼¯S¦a°Ï¤À¨k¤k¡^¡Ð¡Ð¡ÐCOUNTIF($AB$3:$AB$114,">=12")-COUNTIF($AB$3:$AB$114,">17")

­Y·Q§ó§ï¬°¡ã¥¼º¡¢°¢±·³ªº¤k©Ê¤H¼Æ¡H¢°¢±¡ã¢°¢¶·³ªº¤k©Ê¤H¼Æ¡H¡D¡D¡D¡D¡D¨ç¼Æ¤S¸Ó¦p¦ó³]©w¡A½Ð«ü±Ð¡AÁÂÁ¡I

TOP

¥»©«³Ì«á¥Ñ p212 ©ó 2013-12-27 15:44 ½s¿è

¦^´_ 4# onegirl0204
©Ó2#
¥¼º¡¢°¢±·³ªº¤k©Ê¤H¼Æ¡G=SUMPRODUCT(($J$3:$J$114="¤k")*($AA$3:$AA$114<12))
¢°¢±¡Ð¢°¢¶·³ªº¤k©Ê¤H¼Æ¡G=SUMPRODUCT(($J$3:$J$114="¤k")*($AA$3:$AA$114>=12)*($AA$3:$AA$114<17))
½Ð°Ñ¦Ò¡I

TOP

¦^´_ 5# p212

¨Ì·Ó±z´£¨Ñªº¤½¦¡­pºâµ²ªG¦³»~¡A«á¨Ó§Úµo²{¥u­n±N³Ì«á¤@¶µ¼Æ¦r§ï¤@¤U´N¥¿½T¤F¡A¦]¦¹§ó¥¿¦p¤U¡G
¢°¢±¡Ð¢°¢¶·³ªº¤k©Ê¤H¼Æ¡G=SUMPRODUCT(($J$3:$J$114="¤k")*($AA$3:$AA$114>=12)*($AA$3:$AA$114<18))

¦A¦¸·PÁ±zªº¦^ÂСI

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD