ãåããŠã®ããããããŒãã«ãæç5ç§ã§éèšè¡šãäœããæåŒ·ããŒã«ã2æéåã§åºç€ãã身ã«ã€ããè¬åº§
ãExcelã®ããããããŒãã«ã£ãŠèããããšããããã©è€éããã»ã»ã»ã§ã䟿å©ãšã¯èãããã䜿ã£ãŠã¿ããã»ã»ã»ã ãããªããªããžæå ±ã§ãïŒ ããªãã®è²Žéãª1æéãããã ããã°ããããããŒãã«ã䜿ããããã«ãªããŸãïŒ ããã«ãã©ã¹1æéãããã ããã°ãããããããŒãã«ã®ç°¡åãªå¿ç𿹿³ã身ã«ã€ããããšãã§ããŸãïŒ ããããããããããŒãã«ã¯ã©ããªå Žé¢ã§äœ¿ãããã®ãªã®ã§ããããïŒ ããšãã°ãäžåžããããããã¯ååãªã©ããã ã1æé以å ã«ãã®1000è¡ã®ãªã¹ããããç·å¥³æ¯ã®è³Œå ¥ã®åŸåãšã販売æ°ãå€ãååãæããŠã»ããïŒã ãšèšããããã©ãããŸããïŒ SUM颿°ãšãSUMIF颿°ããããããã°SUMIFS颿°ãããããïŒïŒ ããã«ã¯è¡šã®å€æ ãäœã£ãŠã»ã»ã» ããããããããã1æéããè¶³ããªãã»ã»ã» ãããªæã«åãçºæ®ããã®ããä»åã®ã¡ã€ã³å 容ã§ãããããããããŒãã«ãã§ãã ãã©ãã°ïŒããããïŒããŠã¹ãåããïŒã ãã§ãç°¡åã«ãã®ãããªåæããããã®è¡šãäœãããšãã§ããŸãã ãŸãã¯ã玹ä»åç»ãç¡æã§èŠãããšãã§ããåç»ãã芧ããã ããããããããŒãã«ã«ã€ããŠé€ããŠèŠãŠãã ããã ããªãã«Excelã®æ°ããªäžé¢ããèŠãããŸãïŒïŒ