
ðŒãªã ãæ¿ãããç°¡åïŒCOUNTIFã§æé垯å¥ã®ã€ãã³ãä»¶æ°ãèªåéèšããæ¹æ³
ðŒ ã¯ããã«ïŒæã®ãã«ã¯ã¯äœåïŒå€ã®ã颚åã¯äœä»¶ïŒ
è²å èšé²ãæ¥åãã°ãã€ããŠãããšããæé垯ããšã®ä»¶æ°ããææ¡ããããªãç¬éã£ãŠãããŸãããã ã§ããæäœæ¥ã§æ°ããã®ã¯é¢åã ãããã£ã«ã¿ããŠãåèšãåºãªãâŠããããªãšããããCOUNTIFã®åºçªã§ãïŒ
ãã®èšäºã§ã¯ãExcelãGoogleã¹ãã¬ããã·ãŒãã§ãæéåž¯å¥ Ã ã€ãã³ãå¥ãã®ä»¶æ°ãèªåéèšããæ¹æ³ãå³è§£ä»ãã§ãããããã解説ããŸãã
ð ãµã³ãã«ããŒã¿ã®æ§æ

ð¢ COUNTIFã§æé垯ããšã®ä»¶æ°ãéèšãã
â äŸïŒæé垯ãæãã®ä»¶æ°ãæ°ãã
=COUNTIF(D2:D100, "æ")â Dåã§ãæããšäžèŽããã»ã«ã®æ°ãã«ãŠã³ãããŸãã
ð§ COUNTIFã§ã€ãã³ãå¥ Ã æé垯å¥ã®ä»¶æ°ãåºã
â äŸïŒæé垯ãæãã®ããã«ã¯ãä»¶æ°ãæ°ãã
=COUNTIFS(D2:D100, "æ", B2:B100, "ãã«ã¯")â Dåããæãã〠Båãããã«ã¯ãã®è¡ã ããã«ãŠã³ãããŸãã
ð ã»ã«åç §ã§åãæ¿ãå¯èœã«ãã
â ã»ã«C1ã«æé垯ãD1ã«ã€ãã³ãåãå ¥åããŠåãæ¿ã
=COUNTIFS(D2:D100, C1, B2:B100, D1)â C1ã«ãå€ããD1ã«ãã颚åããšå ¥åããã°ãå€ã®ã颚åã®ä»¶æ°ãèªåã§è¡šç€ºãããŸãïŒ
ð§© å³è§£ã§çè§£ããïŒCOUNTIFSã®æ¡ä»¶å€å®ã®æµã
ã¹ããã1ïŒDåãããæé垯ããå€å®
ã¹ããã2ïŒBåãããã€ãã³ãåããå€å®
ã¹ããã3ïŒäž¡æ¹äžèŽããè¡ã ããã«ãŠã³ã
ã¹ããã4ïŒã»ã«åç §ã§åãæ¿ããã°ãã€ã³ã¿ã©ã¯ãã£ããªéèšè¡šã«ïŒ

ð¡ å¿çšãã¯ããã¯
â SUMPRODUCTã§è€éãªæ¡ä»¶ãæ±ã
=SUMPRODUCT((D2:D100="æ")*(B2:B100="ãã«ã¯"))â¡ ããããããŒãã«ã§äžèЧå
æé垯 à ã€ãã³ãåã®ã¯ãã¹éèšãå¯èœ
COUNTIFSããæè»ã«èŠããåã§ãã
⢠ã°ã©ãåããŠåŸåãèŠèŠå
æ£ã°ã©ããåã°ã©ãã§ãæé垯å¥ã€ãã³ãååžããäžç®ã§ææ¡ïŒ
âïž ãŸãšã
COUNTIFã§åäžæ¡ä»¶ãCOUNTIFSã§è€æ°æ¡ä»¶ã®ä»¶æ°ãéèš
ã»ã«åç §ã䜿ãã°ãæé垯 à ã€ãã³ãã®ä»¶æ°ãèªç±ã«åãæ¿ãå¯èœ
FILTERãšçµã¿åãããã°ãæœåº â éèš âå¯èŠåãŸã§äžæ°é貫ïŒ
è²å èšé²ã ãã§ãªããæ¥åãã°ãå®¶èšç°¿ã«ãå¿çšã§ãããã¯ããã¯ã§ãð
ð æ¬¡åäºå
次åã¯ãTEXTJOINã§æé垯å¥ã®ã€ãã³ãå±¥æŽã1ã»ã«ã«ãŸãšããæ¹æ³ãã玹ä»äºå®ã§ãã ãå€ã«äœããŠãïŒããã1ã»ã«ã§äžèŠ§è¡šç€ºã§ããããã«ãªããŸãïŒ
ãExcel颿°ã®åºæ¬ãåŠã¹ãæç§æžã
ð Amazonã§èŠã
â»ãã®èšäºã«ã¯ã¢ãã£ãªãšã€ããªã³ã¯ãå«ãŸããŠããŸã