Excelã«ã¯æ°å€ãã®äŸ¿å©ãªé¢æ°ããããŸããããã®äžã§ãç¹ã«é »ç¹ã«äœ¿çšãããã®ããSUMãé¢æ°ã§ããä»åã¯ãExcelåå¿è ã®æ¹ã§ãç解ããããããã«ãSUMé¢æ°ã®äœ¿ãæ¹ãšå ·äœçãªäŸã玹ä»ããŸãã
â åäœç°å¢
OS: Windows 10 HomeïŒ64ãããïŒ
Excel: 2019ïŒ64ãããïŒ
â SUMé¢æ°ãšã¯ïŒ
SUMé¢æ°ã¯ãæå®ããã»ã«ç¯å²ã®æ°å€ãåèšããããã®é¢æ°ã§ããåºæ¬çãªäœ¿ãæ¹ã¯éåžžã«ç°¡åã§ãæ°å€ã®åèšãæ±ããéã«ãšãŠã䟿å©ã§ãã
â SUMé¢æ°ã®åºæ¬çãªæžåŒ
SUMé¢æ°ã®åºæ¬çãªæžåŒã¯ä»¥äžã®éãã§ãïŒ
ãç¯å²ãã®éšåã«ã¯ãåèšãããã»ã«ã®ç¯å²ãæå®ããŸãã
äŸãã°ãA1ããA3ãŸã§ã®ã»ã«ã®åèšãæ±ããå Žåã¯ããA1:A3ããšæå®ããŸãã
ããã§ã¯ãå ·äœçãªäŸã䜿ã£ãŠSUMé¢æ°ã®äœ¿ãæ¹ãèŠãŠãããŸãããã
äŸ1ïŒåçŽãªåèš
(1)ã»ã«ã«æ°å€ãå ¥åããïŒãŸããB1ããB5ãŸã§ã®ã»ã«ã«æ°å€ãå ¥åããŸãã äŸãã°ã以äžã®ããã«å ¥åããŸãã
B1: 10
B2: 20
B3: 30
B4: 40
B5: 50
(2)SUMé¢æ°ãå ¥åããïŒæ¬¡ã«ãB6ã»ã«ã«ä»¥äžã®ããã«SUMé¢æ°ãå ¥åããŸãã
(3)çµæã確èªããïŒEnterããŒãæŒããšãB1ããB5ãŸã§ã®æ°å€ã®åèšãB6ã»ã«ã«è¡šç€ºãããŸãã ãã®å ŽåãB6ã»ã«ã«ã¯ã150ãã衚瀺ãããŸãã
äŸ2ïŒè€æ°ç¯å²ã®åèš
SUMé¢æ°ã¯ãè€æ°ã®ç¯å²ãæå®ããŠåèšãæ±ããããšãã§ããŸãã
(1)ã»ã«ã«æ°å€ãå ¥åããïŒB1ããB3ãD1ããD3ãŸã§ã®ã»ã«ã«æ°å€ãå ¥åããŸãã äŸãã°ã以äžã®ããã«å ¥åããŸãã
B1: 5
B2: 15
B3: 25
D1: 10
D2: 20
D3: 30
(2)SUMé¢æ°ãå ¥åããïŒæ¬¡ã«ãD5ã»ã«ã«ä»¥äžã®ããã«SUMé¢æ°ãå ¥åããŸãã
(3)çµæã確èªããïŒEnterããŒãæŒããšãB1ããB3ãšD1ããD3ãŸã§ã®æ°å€ã®åèšãD5ã»ã«ã«è¡šç€ºãããŸãããã®å ŽåãD5ã»ã«ã«ã¯ã105ãã衚瀺ãããŸãã
â ãŸãšã
ä»åã¯ãExcelã®åºæ¬é¢æ°ã§ããSUMé¢æ°ã®äœ¿ãæ¹ãšå ·äœäŸã玹ä»ããŸãããSUMé¢æ°ã¯éåžžã«ã·ã³ãã«ã§ãããªãããããŒã¿ã®åèšãæ±ããéã«éåžžã«åŒ·åãªããŒã«ã§ãããŸãã¯åºæ¬çãªäœ¿ãæ¹ããã¹ã¿ãŒããããã«å¿çšã§ããããã«ãªããšãExcelã§ã®äœæ¥ãäžå±€å¹ççã«ãªããŸãã
æ©äŒããã°ãSUMé¢æ°ãããã«å¿çšããSUMIFé¢æ°ãSUMIFSé¢æ°ã®äœ¿ãæ¹ã玹ä»ããããšæããŸããŒã