{"id":19432,"date":"2023-12-05T13:24:51","date_gmt":"2023-12-05T13:24:51","guid":{"rendered":"https:\/\/masterskills.org\/blog\/huong-dan-cach-dung-ham-sumifs-chi-tiet-cuc-don-gian-va-de-hieu.html"},"modified":"2023-12-22T04:49:59","modified_gmt":"2023-12-21T21:49:59","slug":"huong-dan-cach-dung-ham-sumifs-chi-tiet-cuc-don-gian-va-de-hieu","status":"publish","type":"post","link":"https:\/\/masterskills.org\/blog\/huong-dan-cach-dung-ham-sumifs-chi-tiet-cuc-don-gian-va-de-hieu.html","title":{"rendered":"H\u01b0\u1edbng D\u1eabn C\u00e1ch D\u00f9ng H\u00e0m Sumifs Chi Ti\u1ebft C\u1ef1c \u0110\u01a1n Gi\u1ea3n V\u00e0 D\u1ec5 Hi\u1ec3u"},"content":{"rendered":"
\n

Ch\u1eafc h\u1eb3n ch\u00fang ta ai c\u0169ng bi\u1ebft c\u00e1ch t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong Excel b\u1eb1ng h\u00e0m SUM. Tuy nhi\u00ean, n\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n th\u00ec l\u00e0m th\u1ebf n\u00e0o? B\u00e0i vi\u1ebft n\u00e0y, <\/span>Masterskills<\/span> s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi b\u1ea1n <\/span>h\u00e0m Sumifs <\/strong>– m\u1ed9t h\u00e0m r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 <\/span>t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong>. N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng <\/span>h\u00e0m Sumifs<\/strong> th\u00ec \u0111\u1eebng b\u1ecf qua b\u00e0i vi\u1ebft n\u00e0y nh\u00e9.\u00a0<\/span><\/p>\n

Trong Excel, h\u00e0m Sumifs d\u00f9ng \u0111\u1ec3 l\u00e0m g\u00ec?<\/strong><\/h2>\n

Gi\u1ed1ng nh\u01b0 t\u00ean g\u1ecdi, <\/span>h\u00e0m Sumifs<\/strong> trong Excel\u00a0 l\u00e0 s\u1ef1 k\u1ebft h\u1ee3p c\u1ee7a h\u00e0m SUM v\u00e0 h\u00e0m IFS. Do v\u1eady, h\u00e0m Sumifs s\u1ebd t\u00edch h\u1ee3p 2 ch\u1ee9c n\u0103ng l\u00e0 t\u00ednh t\u1ed5ng c\u1ee7a h\u00e0m SUM v\u00e0 \u00e1p d\u1ee5ng c\u00f9ng l\u00fac nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n cho d\u1eef li\u1ec7u c\u1ee7a h\u00e0m IFS. Nh\u01b0 v\u1eady, h\u00e0ng Sumifs l\u00e0 h\u00e0m <\/span>t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n <\/strong>trong Excel.<\/span><\/p>\n

L\u1ee3i \u00edch c\u1ee7a vi\u1ec7c d\u00f9ng h\u00e0m Sumifs<\/strong><\/h3>\n

H\u00e0m Sumifs cho ph\u00e9p m\u1edf r\u1ed9ng ch\u1ee9c n\u0103ng c\u1ee7a h\u00e0m SUM. Thay v\u00ec ch\u1ec9 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng trong m\u1ed9t ph\u1ea1m vi nh\u1ea5t \u0111\u1ecbnh th\u00ec Sumifs s\u1ebd t\u00ednh t\u1ed5ng \u0111\u01b0\u1ee3c t\u1ea5t c\u1ea3 c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n b\u1ea1n \u0111\u01b0a v\u00e0o tham s\u1ed1 criteria.<\/span><\/p>\n

S\u1eed d\u1ee5ng h\u00e0m Sumifs s\u1ebd mang l\u1ea1i ti\u1ec7n l\u1ee3i, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian n\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng doanh thu c\u1ee7a c\u00f4ng ty, doanh s\u1ed1 c\u1ee7a nh\u00e2n vi\u00ean trong kho\u1ea3ng th\u1eddi gian n\u00e0o \u0111\u00f3, ho\u1eb7c t\u1ed5ng l\u01b0\u01a1ng theo \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n

<\/span><\/p>\n

    \n<\/ul>\n

    \"H\u00e0m<\/p>\n

    H\u00e0m Sumifs \u1ee9ng d\u1ee5ng hi\u1ec7u qu\u1ea3 \u0111\u1ec3 t\u00ednh to\u00e1n doanh thu, doanh s\u1ed1 c\u1ee7a nh\u00e2n vi\u00ean (Ngu\u1ed3n: Internet)<\/span><\/p>\n

    C\u00f4ng th\u1ee9c h\u00e0m Sumifs trong Excel<\/strong><\/h2>\n

    H\u00e0m Sumifs s\u1ebd ph\u1ee9c t\u1ea1p h\u01a1n so v\u1edbi h\u00e0m Sumif. C\u00f4ng th\u1ee9c h\u00e0m Sumifs c\u00f3 d\u1ea1ng sau:<\/span><\/p>\n

    =Sumifs (sum_range,criteria_range1,criteria1,criteria_range2,criteria2,\u2026)\u00a0<\/span><\/p>\n

      \n<\/ul>\n

      \u00a0<\/p>\n

        \n<\/ul>\n
          \n<\/ul>\n

          \u00a0<\/p>\n

          :<\/span><\/p>\n

            \n<\/ul>\n

            V\u00ed d\u1ee5 c\u1ee5 th\u1ec3 v\u1ec1 c\u00e1ch d\u00f9ng h\u00e0m Sumifs \u0111\u1ec3 t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong><\/h3>\n

            V\u00ed d\u1ee5 1: H\u00e0m Sumifs c\u01a1 b\u1ea3n<\/strong><\/p>\n

            Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng Excel t\u1ed5ng h\u1ee3p nh\u1eefng l\u00f4 h\u00e0ng hoa qu\u1ea3 v\u1edbi nhi\u1ec1u nh\u00e0 cung \u1ee9ng kh\u00e1c nhau. Nhi\u1ec7m v\u1ee5 c\u1ee7a b\u1ea1n s\u1ebd l\u00e0 t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng m\u1eb7t h\u00e0ng c\u1ee7a m\u1ed9t nh\u00e0 cung c\u1ea5p x\u00e1c \u0111\u1ecbnh. C\u1ee5 th\u1ec3 l\u00e0 s\u1ed1 l\u01b0\u1ee3ng t\u00e1o \u0111\u01b0\u1ee3c Ph\u00e1t cung c\u1ea5p. H\u00e3y s\u1eed d\u1ee5ng <\/span>h\u00e0m Sumifs<\/strong> trong Excel \u0111\u1ec3 t\u00ednh.<\/span><\/p>\n

            <\/span><\/p>\n

            V\u00ed d\u1ee5 h\u00e0m Sumifs c\u01a1 b\u1ea3n (Ngu\u1ed3n: Internet)<\/span><\/p>\n

            C\u00e1ch l\u00e0m:\u00a0<\/strong><\/p>\n

            X\u00e1c \u0111\u1ecbnh c\u00e1c tham s\u1ed1<\/span><\/p>\n

              \n<\/ul>\n

              Nh\u01b0 v\u1eady, c\u00f4ng th\u1ee9c <\/span>h\u00e0m Sumifs<\/strong> s\u1ebd c\u00f3 d\u1ea1ng:<\/span><\/p>\n

              = Sumifs(C2:C9,A2:A9,\u201dT\u00e1o\u201d,B2:B9,\u201dPh\u00e1t\u201d)<\/span><\/p>\n

              Trong b\u1ea3ng t\u00ednh, ch\u1ec9 c\u00f3 \u00f4 C4 v\u00e0 C9 l\u00e0 \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n \u201cs\u1ed1 l\u01b0\u1ee3ng T\u00e1o \u0111\u01b0\u1ee3c Ph\u00e1t cung c\u1ea5p\u201d. Do v\u1eady, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 t\u1ed5ng c\u1ee7a \u00f4 C4 v\u00e0 C9.<\/span><\/p>\n

              <\/span><\/p>\n

              C\u00f4ng th\u1ee9c h\u00e0m Sumif t\u00ednh s\u1ed1 l\u01b0\u1ee3ng t\u00e1o \u0111\u01b0\u1ee3c Ph\u00e1t cung c\u1ea5p (Ngu\u1ed3n: Internet)<\/span><\/p>\n

              \u0110\u1ec3 c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft criteria1 b\u1eb1ng F1, criteria2 b\u1eb1ng F2. L\u00fac n\u00e0y, h\u00e0m Sumifs \u0111\u01b0\u1ee3c vi\u1ebft nh\u01b0 sau:<\/span><\/p>\n

              =Sumifs (C2:C9, A2:A9, F1, B2:B9, F2)<\/span><\/p>\n

              V\u00ed d\u1ee5 2: H\u00e0m Sumifs v\u1edbi to\u00e1n t\u1eed so s\u00e1nh<\/strong><\/p>\n

              C\u0169ng v\u1edbi v\u00ed d\u1ee5 tr\u00ean, l\u1ea7n n\u00e0y b\u1ea1n c\u00f3 nhi\u1ec7m v\u1ee5 t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng hoa qu\u1ea3 m\u00e0 Mai cung c\u1ea5p, \u0111i\u1ec1u ki\u1ec7n l\u00f4 h\u00e0ng ph\u1ea3i ch\u1ee9a t\u1eeb 200 s\u1ea3n ph\u1ea9m tr\u1edf l\u00ean.<\/span><\/p>\n

              C\u00e1ch l\u00e0m:<\/strong><\/p>\n

              \n

              H\u00e0m Sumifs v\u1edbi to\u00e1n t\u1eed so s\u00e1nh (Ngu\u1ed3n: Internet)<\/span><\/p>\n

              h\u00e0m Sumifs<\/strong><\/p>\n

              \n

              T\u01b0\u01a1ng t\u1ef1, n\u1ebfu b\u1ea1n c\u1ea7n t\u00ednh t\u1ed5ng gi\u00e1 tr\u1ecb trong ph\u1ea1m vi C2:C9 v\u1edbi \u0111i\u1ec1u ki\u1ec7n n\u1eb1m trong kho\u1ea3ng 100 v\u00e0 250 th\u00ec s\u1ebd s\u1eed d\u1ee5ng \u201cl\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng\u201d (>=) ho\u1eb7c nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng (<=):<\/span><\/p>\n

              =Sumifs (C2:C9,C2:C9,\u201c>=100\u201d,C2:C9,\u201c<=150\u201d)<\/span><\/p>\n

              L\u01b0u \u00fd: C\u00e1c bi\u1ec3u th\u1ee9c so s\u00e1nh c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p (\u201c\u201d)<\/span><\/p>\n

              \u00a0<\/span><\/p>\n

                \n<\/ul>\n

                Nh\u1eefng l\u1ed7i th\u00f4ng th\u01b0\u1eddng hay m\u1eafc ph\u1ea3i khi d\u00f9ng h\u00e0m Sumifs<\/strong><\/h3>\n

                L\u1ed7i #VALUE!:<\/strong><\/p>\n

                  \n<\/ul>\n

                  <\/span><\/p>\n

                  L\u1ed7i #VALUE! trong h\u00e0m Sumifs (Ngu\u1ed3n: Internet)<\/span><\/p>\n

                  L\u1ed7i chu\u1ed7i ti\u00eau th\u1ee9c c\u00f3 nhi\u1ec1u h\u01a1n 255 k\u00fd t\u1ef1<\/strong><\/p>\n

                    \n<\/ul>\n

                    \u0110\u1ed1i s\u1ed1 criteria_range kh\u00f4ng nh\u1ea5t qu\u00e1n v\u1edbi sum_range<\/strong><\/p>\n

                      \n<\/ul>\n

                      Khi d\u00f9ng h\u00e0m t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u1ea7n l\u01b0u \u00fd nh\u1eefng g\u00ec?<\/strong><\/h2>\n
                        \n<\/ul>\n

                        :<\/span><\/p>\n

                          \n<\/ul>\n

                          \n

                          Nh\u1eefng l\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Sumifs (Ngu\u1ed3n: Internet)<\/span><\/p>\n

                          Nh\u01b0 v\u1eady, vi\u1ec7c s\u1eed d\u1ee5ng <\/span>h\u00e0m Sumifs<\/strong> trong Excel \u0111\u1ec3 <\/span>t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/strong> s\u1ebd gi\u00fap b\u1ea1n t\u1ed5ng h\u1ee3p, x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch logic h\u01a1n. Hy v\u1ecdng qua b\u00e0i vi\u1ebft tr\u00ean b\u1ea1n \u0111\u00e3 hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c <\/span>h\u00e0m Sumifs<\/strong> m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t. \u0110\u1ec3 kh\u00e1m ph\u00e1 nhi\u1ec1u h\u01a1n v\u1ec1 c\u00e1c h\u00e0m trong Excel, h\u00e3y theo d\u00f5i c\u00e1c b\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt m\u1ed7i ng\u00e0y tr\u00ean website c\u1ee7a <\/span>Masterskills<\/span>nh\u00e9.<\/span><\/span><\/p>\n

                          \u00a0<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

                          h\u00e0m Sumifs <\/strong><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[431],"tags":[],"_links":{"self":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19432"}],"collection":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/comments?post=19432"}],"version-history":[{"count":0,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/posts\/19432\/revisions"}],"wp:attachment":[{"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/media?parent=19432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/categories?post=19432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/masterskills.org\/blog\/wp-json\/wp\/v2\/tags?post=19432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}