è¤æ°æ¡ä»¶ãæºãããã¼ã¿ã®ä»¶æ°ãæ±ããã«ã¯ ãcountifã»countifsã»sumproductã 2003/2007/2010/2013. ã§ç´¹ä»ããsumifs颿°ã¨countifs颿°ã§ã¯è¤æ°ã®æ¡ä»¶ãæå®ã§ããããand颿°ãç¨ããå ´åã¨åãå¤å®ãè¡ããã¨ã«ãªãã countifs颿°ã¯æå®ããç¯å²ã®ä¸ã§è¤æ°ã®æ¤ç´¢æ¡ä»¶ã«ä¸è´ããã»ã«ãããã¤ããããæ±ãã颿°ã§ããcountifs颿°ã®åºæ¬çãªä½¿ãæ¹ããç´¹ä»ãã¦ããã¾ããã¯ã¤ã«ãã«ã¼ããæ¯è¼æ¼ç®åãªã©ãã¾ãã¾ãªæ¤ç´¢æ¡ä»¶ã®æå®æ¹æ³ã説æãã¾ãã countif颿°ã§è¤æ°æ¡ä»¶. COUNTIFS(æ¤ç´¢æ¡ä»¶ç¯å²1,æ¤ç´¢æ¡ä»¶1,æ¤ç´¢æ¡ä»¶ç¯å²2,æ¤ç´¢æ¡ä»¶2...) Excel2007ã§è¿½å ããã颿°ã§ãã æ¡ä»¶ã¯ãæ¡ä»¶1ANDæ¡ä»¶2...ãã®ANDã§ã®çµæã«ãªãã¾ãã è¤æ°ã®æ¡ä»¶ã§ã»ã«ã®åæ°ãã«ã¦ã³ãããã㨠⦠excelã§ãã¼ã¿ãæ°ãã颿°ã®ä»£è¡¨æ ¼ã¯countif颿°ã§ãããè¤æ°æ¡ä»¶ãæå®ããå¿
è¦ããããªããcountifsï¼ã«ã¦ã³ãã»ã¤ãã»ã¨ã¹ï¼é¢æ°ã®åºçªã§ããåºæ¬ã¯ãaãã¤bãã®andæ¡ä»¶ã¨ãªãã¾ãããååæ¼ç®ã®çµã¿åããã§ãaã¾ãã¯bãã®oræ¡ä»¶ã«ãããã¨ãå¯è½ã§ãã countifs颿°ã§æ¥ä»ã空ç½ã空ç½ä»¥å¤ãæååãæ°å¤ã®æ¡ä»¶æå®; countifs颿°ã§ä»¥ä¸ã»ä»¥ä¸ãªã©ã®ç¯å²ã»æéæå®ãæ¡ä»¶ã«ãã; indexã¨match颿°ã§countifs颿°ã®æ¤ç´¢æ¡ä»¶ãã¾ã¨ãã¦åãæãã ã¨ã¯ã»ã«countif颿°ã¯ã1ã¤ã®æ¡ä»¶ã§ãã»ã«ã®åæ°ãã«ã¦ã³ããã颿°ã§ãããæ¡ä»¶ã«æ¥ä»ãæå®ãã¦ãæéãç¯å²ãæå®ãããã¨ãã§ãã¾ããcountif颿°ã§ãæ¥ä»ã®æéãç¯å²ãæå®ããå ´åã¯ãè¤æ°æ¡ä»¶ãandã¨orã«ãªãã¾ãã countifs颿°ã®ä½¿ãæ¹ï½è¤æ°æ¡ä»¶ä¸è´ã®ãã¼ã¿ã«ã¦ã³ãæ°å¤ã»æ¥ä»ç. ã¨ã¯ã»ã«countifs颿°ã¯ãè¤æ°æ¡ä»¶ã«ä¸è´ãããã»ã«ã®åæ°ãã«ã¦ã³ããã颿°ã§ããcountifs颿°ã®è¤æ°æ¡ä»¶ã¯ãandã«ãªãã¾ãããè¤æ°æ¡ä»¶or(ã¾ãã¯)ãæå®ãã¦ãã»ã«ãã«ã¦ã³ããããã¨ãã§ãã¾ãã ã¼ãã®countifs颿°ã®ä½¿ãæ¹ãcountif颿°ã§è¤æ°æ¡ä»¶ã®andæ¡ä»¶ã§ä¸è´ãããã¼ã¿ã®æ°ãæ°ãããã¨ãã§ãã颿°ã§ãã countif颿°ã§ã«ã¦ã³ãã§ããç¯å²ã¯ä¸åã ãã£ã¦æã£ã¦ãã¾ãããï¼ ãããªãã¨ã¯ããã¾ãããå®ã¯ è¤æ°ç¯å²æå®ãããã¨ãã§ãã ãã§ãã. COUNTIFS颿° ã¯ãè¤æ°ã®ç¯å²ã®ã»ã«ã«æ¡ä»¶ãé©ç¨ãã¦ããã¹ã¦ã®æ¡ä»¶ãæºããããåæ°ãã«ã¦ã³ãããã Excel2007以éã®ãã¼ã¸ã§ã³ã§ä½¿ç¨å¯ andæ¡ä»¶ã®è¤æ°æ¡ä»¶ãæºãããã¼ã¿ã®ä»¶æ°ãæ±ããæ¹æ³ã§ãã excel2003以åã¯ãã®ãã®ã®é¢æ°ã¯ããã¾ããã§ãããããããã®è¦æã¯ããªãå¤ãã£ãããã«æãã¾ãã countifs颿°ã¯è¤æ°ã®æ¡ä»¶ã«åè´ãããã¼ã¿æ°ãæ°ãããã¨ãã§ãã¾ãã (å
¨æ¡ä»¶ã«åè´ãªã®ã§ANDæ¡ä»¶ï¼ = COUNTIFS( æ¡ä»¶ç¯å²1 , "æ¡ä»¶1" , æ¡ä»¶ç¯å²2 ," æ¡ä»¶2" , æ¡ä»¶ç¯å²3 , "æ¡ä»¶3" â¦ï¼ ããã§ã¯ãããªå°ã£ããè§£æ¶ããããã«ãcountif颿°ã§è¤æ°ç¯å²ãæå®ãã¦ã«ã¦ã³ãããæ¹æ³ã«ã¤ãã¦è§£èª¬ãã¾ãã