{"id":5225,"date":"2025-11-24T17:09:52","date_gmt":"2025-11-24T10:09:52","guid":{"rendered":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-sumproduct-trong-excel-chi-tiet-de-hieu\/"},"modified":"2025-11-24T17:09:52","modified_gmt":"2025-11-24T10:09:52","slug":"cach-su-dung-ham-sumproduct-trong-excel-chi-tiet-de-hieu","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/cach-su-dung-ham-sumproduct-trong-excel-chi-tiet-de-hieu\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong Excel chi ti\u1ebft, d\u1ec5 hi\u1ec3u"},"content":{"rendered":"
\n
\u00a0<\/div>\n

\u0110\u1ec3 r\u00fat ng\u1eafn c\u00e1c thao t\u00e1c t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel, h\u00e0m SUMPRODUCT l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 mang l\u1ea1i hi\u1ec7u qu\u1ea3 r\u00f5 r\u1ec7t. H\u00e0m cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o th\u00eam c\u1ed9t ph\u1ee5, gi\u00fap b\u1ea3ng t\u00ednh r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 qu\u1ea3n l\u00fd h\u01a1n. B\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT chi ti\u1ebft k\u00e8m v\u00ed d\u1ee5 \u0111\u1ec3 d\u1ec5 hi\u1ec3u.<\/p>\n

\"C\u00e1chH\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong Excel<\/em><\/p>\n

\n

1. H\u00e0m SUMPRODUCT l\u00e0 g\u00ec?<\/h2>\n<\/div>\n

H\u00e0m SUMPRODUCT l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong Excel. C\u00e1ch ho\u1ea1t \u0111\u1ed9ng c\u1ee7a h\u00e0m l\u00e0 nh\u00e2n t\u1eebng ph\u1ea7n t\u1eed t\u01b0\u01a1ng \u1ee9ng gi\u1eefa hai ho\u1eb7c nhi\u1ec1u m\u1ea3ng d\u1eef li\u1ec7u, sau \u0111\u00f3 c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c k\u1ebft qu\u1ea3 l\u1ea1i \u0111\u1ec3 cho ra t\u1ed5ng cu\u1ed1i c\u00f9ng.<\/p>\n

V\u00ed d\u1ee5:<\/strong> B\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng g\u1ed3m nhi\u1ec1u s\u1ea3n ph\u1ea9m k\u00e8m theo s\u1ed1 l\u01b0\u1ee3ng v\u00e0 \u0111\u01a1n gi\u00e1. Khi mu\u1ed1n t\u00ednh t\u1ed5ng ti\u1ec1n, b\u1ea1n th\u01b0\u1eddng ph\u1ea3i nh\u00e2n S\u1ed1 l\u01b0\u1ee3ng \u00d7 \u0110\u01a1n gi\u00e1<\/strong> cho t\u1eebng s\u1ea3n ph\u1ea9m r\u1ed3i c\u1ed9ng l\u1ea1i. H\u00e0m SUMPRODUCT cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n c\u1ea3 hai b\u01b0\u1edbc n\u00e0y c\u00f9ng l\u00fac: Nh\u00e2n t\u1eebng c\u1eb7p gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u00e0 t\u00ednh t\u1ed5ng ngay l\u1eadp t\u1ee9c.<\/p>\n

\"S\u1eedV\u00ed d\u1ee5 v\u1ec1 h\u00e0m SUMPRODUCT<\/em><\/p>\n

\n

2. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SUMPRODUCT<\/h2>\n<\/div>\n

C\u00fa ph\u00e1p:<\/strong>=SUMPRODUCT(array1; array2; array3; \u2026)<\/strong><\/p>\n

Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

    \n
  • array1:<\/strong> \u0110\u00e2y l\u00e0 m\u1ea3ng b\u1eaft bu\u1ed9c, ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m s\u1ebd l\u1ea5y \u0111\u1ec3 nh\u00e2n v\u1edbi nh\u1eefng m\u1ea3ng t\u01b0\u01a1ng \u1ee9ng kh\u00e1c tr\u01b0\u1edbc khi c\u1ed9ng t\u1ed5ng.<\/li>\n
  • array2, array3,\u2026:<\/strong> L\u00e0 c\u00e1c m\u1ea3ng b\u1ed5 sung (t\u1ed1i \u0111a \u0111\u1ebfn 225 m\u1ea3ng). C\u00e1c m\u1ea3ng n\u00e0y cung c\u1ea5p nh\u1eefng gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u0111\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e9p nh\u00e2n v\u00e0 sau \u0111\u00f3 c\u1ed9ng t\u1ed5ng k\u1ebft qu\u1ea3.<\/li>\n<\/ul>\n
    Xem th\u00eam: <\/strong>C\u00e1ch d\u00f9ng h\u00e0m ROUNDDOWN trong Excel \u0111\u1ec3 l\u00e0m tr\u00f2n gi\u00e1 tr\u1ecb<\/div>\n
    \n

    3. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT t\u00ednh t\u1ed5ng \u0111i\u1ec1u ki\u1ec7n<\/h2>\n<\/div>\n
    \n

    3.1 T\u00ednh t\u1ed5ng v\u1edbi hai \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<\/div>\n

    V\u00ed d\u1ee5:<\/strong> Gi\u1ea3 s\u1eed b\u1ea1n c\u1ea7n t\u00ecm t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a c\u00e1c m\u1eb7t h\u00e0ng N\u1ed9i th\u1ea5t \u0111\u1ed3ng th\u1eddi c\u00f3 qu\u00e0 t\u1eb7ng l\u00e0 Th\u1ea3m trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

    Ph\u00e2n t\u00edch \u0111i\u1ec1u ki\u1ec7n: B\u00e0i to\u00e1n c\u00f3 2 \u0111i\u1ec1u ki\u1ec7n c\u1ea7n ki\u1ec3m tra:<\/p>\n

      \n
    • C\u1ed9t Lo\u1ea1i ph\u1ea3i l\u00e0 N\u1ed9i th\u1ea5t<\/li>\n
    • C\u1ed9t Qu\u00e0 t\u1eb7ng ph\u1ea3i l\u00e0 Th\u1ea3m<\/li>\n<\/ul>\n

      S\u1ed1 l\u01b0\u1ee3ng c\u1ea7n c\u1ed9ng n\u1eb1m \u1edf c\u1ed9t H.<\/p>\n

      \u0110\u1ec3 x\u1eed l\u00fd hai \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac, ta s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT k\u1ebft h\u1ee3p c\u00e1c ph\u00e9p so s\u00e1nh logic.<\/p>\n

      B\u01b0\u1edbc 1: Nh\u1eadp h\u00e0m<\/h4>\n

      T\u1ea1i \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng, b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c:\u00a0<\/p>\n

      =SUMPRODUCT((D6:D14=D7)*(E6:E14=E8)*H6:H14)<\/strong><\/p>\n

      Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

        \n
      • (D6:D14 = D7):<\/strong> Ki\u1ec3m tra t\u1eebng d\u00f2ng xem lo\u1ea1i s\u1ea3n ph\u1ea9m c\u00f3 tr\u00f9ng v\u1edbi \u201cN\u1ed9i th\u1ea5t\u201d kh\u00f4ng.<\/li>\n
      • (E6:E14 = E8):<\/strong> Ki\u1ec3m tra qu\u00e0 t\u1eb7ng c\u1ee7a t\u1eebng d\u00f2ng c\u00f3 ph\u1ea3i \u201cTh\u1ea3m\u201d kh\u00f4ng.<\/li>\n
      • H6:H14:<\/strong> L\u1ea5y s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng c\u1ee7a nh\u1eefng d\u00f2ng th\u1ecfa c\u1ea3 hai \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<\/ul>\n

        Hai m\u1ea3ng \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang\/sai \u0111\u01b0\u1ee3c nh\u00e2n v\u1edbi nhau \u0111\u1ec3 t\u1ea1o th\u00e0nh m\u1ea3ng l\u1ecdc ch\u00ednh x\u00e1c, sau \u0111\u00f3 nh\u00e2n ti\u1ebfp v\u1edbi c\u1ed9t s\u1ed1 l\u01b0\u1ee3ng v\u00e0 c\u1ed9ng t\u1ed5ng.<\/p>\n

        \"Nh\u1eadpC\u00e1ch thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c SUMPRODUCT v\u1edbi hai \u0111i\u1ec1u ki\u1ec7n<\/em><\/p>\n

        B\u01b0\u1edbc 2: Nh\u1ea5n Enter<\/h4>\n

        Excel s\u1ebd x\u1eed l\u00fd to\u00e0n b\u1ed9 \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 ngay. Trong v\u00ed d\u1ee5 n\u00e0y k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 17.\u00a0<\/p>\n

        \"K\u1ebftK\u1ebft qu\u1ea3 sau khi nh\u1ea5n Enter<\/em><\/p>\n

        \n

        3.2 T\u00ednh t\u1ed5ng v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/h3>\n<\/div>\n

        V\u00ed d\u1ee5:<\/strong> T\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng c\u1ee7a nh\u1eefng s\u1ea3n ph\u1ea9m thu\u1ed9c lo\u1ea1i \u201cB\u201d, c\u00f3 gi\u00e1 l\u1edbn h\u01a1n 100 v\u00e0 \u0111\u01b0\u1ee3c b\u00e1n trong th\u00e1ng 6.\u00a0<\/p>\n

        B\u01b0\u1edbc 1: <\/strong>T\u1ea1i \u00f4 c\u1ea7n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

        =SUMPRODUCT((A2:A11=”B”)*(C2:C11>100)*(MONTH(D2:D11)=6)*B2:B11)<\/strong><\/p>\n

        Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

          \n
        • A2:A11=”B”:<\/strong> Ch\u1ecdn c\u00e1c d\u00f2ng c\u00f3 s\u1ea3n ph\u1ea9m lo\u1ea1i B.<\/li>\n
        • C2:C11>100:<\/strong> L\u1ecdc nh\u1eefng s\u1ea3n ph\u1ea9m c\u00f3 gi\u00e1 v\u01b0\u1ee3t 100.<\/li>\n
        • MONTH(D2:D11)=6:<\/strong> Gi\u1eef l\u1ea1i c\u00e1c d\u00f2ng c\u00f3 ng\u00e0y b\u00e1n thu\u1ed9c th\u00e1ng 6.<\/li>\n
        • B2:B11:<\/strong> M\u1ea3ng ch\u1ee9a s\u1ed1 l\u01b0\u1ee3ng s\u1ebd \u0111\u01b0\u1ee3c c\u1ed9ng t\u1ed5ng khi th\u1ecfa m\u00e3n to\u00e0n b\u1ed9 \u0111i\u1ec1u ki\u1ec7n.<\/li>\n<\/ul>\n

          \"Nh\u1eadpNh\u1eadp c\u00f4ng th\u1ee9c SUMPRODUCT theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/em><\/p>\n

          B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter \u0111\u1ec3 nh\u1eadn k\u1ebft qu\u1ea3. K\u1ebft qu\u1ea3 c\u1ee7a v\u00ed d\u1ee5 n\u00e0y l\u00e0 175.<\/p>\n

          \"K\u1ebftK\u1ebft qu\u1ea3 t\u00ednh t\u1ed5ng nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng SUMPRODUCT<\/em><\/p>\n

          \n

          3.3 K\u1ebft h\u1ee3p v\u1edbi c\u00e1c h\u00e0m logic kh\u00e1c<\/h3>\n<\/div>\n

          V\u00ed d\u1ee5:<\/strong> T\u00ednh s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m thu\u1ed9c nh\u00f3m Ph\u1ee5 ki\u1ec7n ho\u1eb7c Gia d\u1ee5ng v\u00e0 c\u00f3 qu\u00e0 t\u1eb7ng k\u00e8m l\u00e0 Voucher<\/p>\n

          B\u01b0\u1edbc 1:<\/strong> \u0110\u1ec3 th\u1ef1c hi\u1ec7n, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p SUMPRODUCT v\u1edbi OR \u0111\u1ec3 t\u1ea1o \u0111i\u1ec1u ki\u1ec7n l\u1ecdc hai lo\u1ea1i s\u1ea3n ph\u1ea9m c\u00f9ng l\u00fac. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng l\u00e0:\u00a0<\/p>\n

          =SUMPRODUCT(((D6:D14=D10)+(D6:D14=D11))*(E6:E14=E11)*H6:H14)<\/strong><\/p>\n

          Gi\u1ea3i th\u00edch:<\/strong><\/p>\n

            \n
          • ((D6:D14=D10)+(D6:D14=D11)):<\/strong> S\u1eed d\u1ee5ng + \u0111\u1ec3 t\u1ea1o \u0111i\u1ec1u ki\u1ec7n OR cho ph\u00e9p t\u00ednh t\u1ed5ng n\u1ebfu s\u1ea3n ph\u1ea9m thu\u1ed9c Ph\u1ee5 ki\u1ec7n ho\u1eb7c Gia d\u1ee5ng.<\/li>\n
          • (E6:E14=E11):<\/strong> L\u1ecdc c\u00e1c s\u1ea3n ph\u1ea9m c\u00f3 qu\u00e0 t\u1eb7ng l\u00e0 Th\u1ea3m.<\/li>\n
          • H6:H14:<\/strong> L\u1ea5y gi\u00e1 tr\u1ecb s\u1ed1 l\u01b0\u1ee3ng t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n

            \"S\u1eedL\u1ecdc hai lo\u1ea1i s\u1ea3n ph\u1ea9m b\u1eb1ng OR<\/em><\/p>\n

            B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Enter, Excel s\u1ebd t\u00ednh to\u00e1n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3. Trong v\u00ed d\u1ee5 n\u00e0y k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 34<\/p>\n

            \"K\u1ebftK\u1ebft qu\u1ea3 t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng l\u00e0 34<\/em><\/p>\n

            \n

            4. L\u01b0u \u00fd khi d\u00f9ng h\u00e0m SUMPRODUCT<\/h2>\n<\/div>\n

            Khi l\u00e0m vi\u1ec7c v\u1edbi h\u00e0m SUMPRODUCT, b\u1ea1n n\u00ean \u0111\u1ec3 \u00fd m\u1ed9t v\u00e0i \u0111i\u1ec3m \u0111\u01a1n gi\u1ea3n sau \u0111\u1ec3 tr\u00e1nh l\u1ed7i trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n:<\/p>\n

              \n
            • H\u1ea1n ch\u1ebf \u0111\u01b0a v\u00e0o c\u00f4ng th\u1ee9c c\u00e1c gi\u00e1 tr\u1ecb nh\u01b0 ch\u1eef, k\u00fd t\u1ef1 hay \u00f4 tr\u1ed1ng v\u00ec ch\u00fang c\u00f3 th\u1ec3 l\u00e0m sai k\u1ebft qu\u1ea3.<\/li>\n
            • C\u00e1c m\u1ea3ng d\u00f9ng trong h\u00e0m ph\u1ea3i c\u00f3 c\u00f9ng s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t \u0111\u1ec3 Excel x\u1eed l\u00fd \u0111\u00fang.<\/li>\n
            • N\u1ebfu trong m\u1ed9t m\u1ea3ng c\u00f3 \u00f4 ch\u1ee9a v\u0103n b\u1ea3n, Excel s\u1ebd t\u1ef1 xem gi\u00e1 tr\u1ecb \u0111\u00f3 b\u1eb1ng 0 khi th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh.<\/li>\n<\/ul>\n
              \n

              5. M\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m SUMPRODUCT<\/h2>\n<\/div>\n
              \n

              5.1 L\u1ed7i #VALUE!<\/h3>\n<\/div>\n

              L\u1ed7i #VALUE! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi c\u00e1c v\u00f9ng d\u1eef li\u1ec7u trong h\u00e0m SUMPRODUCT kh\u00f4ng c\u00f3 c\u00f9ng s\u1ed1 \u00f4.<\/p>\n

              V\u00ed d\u1ee5, b\u1ea1n ch\u1ecdn:<\/strong><\/p>\n

                \n
              • C\u1ed9t \u0110\u01a1n gi\u00e1 g\u1ed3m 5 d\u00f2ng<\/li>\n
              • C\u1ed9t S\u1ed1 l\u01b0\u1ee3ng ch\u1ec9 c\u00f3 3 d\u00f2ng<\/li>\n<\/ul>\n

                Khi \u0111\u00f3, SUMPRODUCT kh\u00f4ng th\u1ec3 \u201cgh\u00e9p c\u1eb7p\u201d t\u1eebng \u00f4 \u0111\u1ec3 nh\u00e2n, n\u00ean tr\u1ea3 v\u1ec1 l\u1ed7i #VALUE!.<\/p>\n

                \u0110\u1ec3 kh\u1eafc ph\u1ee5c, h\u00e3y ki\u1ec3m tra l\u1ea1i c\u00e1c m\u1ea3ng trong c\u00f4ng th\u1ee9c v\u00e0 ch\u1ec9nh ph\u1ea1m vi sao cho t\u1ea5t c\u1ea3 m\u1ea3ng \u0111\u1ec1u c\u00f3 c\u00f9ng k\u00edch th\u01b0\u1edbc.<\/p>\n

                \"B\u00e1oV\u00ed d\u1ee5 th\u00f4ng b\u00e1o l\u1ed7i #VALUE! khi s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT<\/em><\/p>\n

                \n

                5.2 K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 b\u1eb1ng 0<\/h3>\n<\/div>\n

                Tr\u01b0\u1eddng h\u1ee3p kh\u00f4ng b\u00e1o l\u1ed7i nh\u01b0ng k\u1ebft qu\u1ea3 l\u1ea1i b\u1eb1ng 0 th\u01b0\u1eddng do trong m\u1ea3ng c\u00f3 nhi\u1ec1u gi\u00e1 tr\u1ecb m\u00e0 h\u00e0m kh\u00f4ng th\u1ec3 d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n, ch\u1eb3ng h\u1ea1n nh\u01b0:<\/p>\n

                  \n
                • \u00d4 ch\u1ee9a v\u0103n b\u1ea3n<\/li>\n
                • \u00d4 tr\u1ed1ng<\/li>\n
                • Gi\u00e1 tr\u1ecb l\u00e0 h\u00e0m logic (TRUE\/FALSE)<\/li>\n<\/ul>\n

                  Ch\u1eb3ng h\u1ea1n, n\u1ebfu v\u00f9ng d\u1eef li\u1ec7u C4:C8 to\u00e0n l\u00e0 ch\u1eef (kh\u00f4ng ph\u1ea3i s\u1ed1), khi \u0111\u01b0a v\u00e0o SUMPRODUCT, Excel s\u1ebd xem c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00f3 l\u00e0 0, n\u00ean t\u1ed5ng cu\u1ed1i c\u00f9ng c\u0169ng b\u1eb1ng 0.<\/p>\n

                  \"K\u1ebftM\u1ea3ng ch\u1ee9a ch\u1eef n\u00ean SUMPRODUCT tr\u1ea3 v\u1ec1 0<\/em><\/p>\n

                  H\u00e0m SUMPRODUCT l\u00e0 c\u00f4ng c\u1ee5 m\u1ea1nh gi\u00fap b\u1ea1n x\u1eed l\u00fd c\u00e1c ph\u00e9p t\u00ednh nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o c\u1ed9t ph\u1ee5, t\u1eeb \u0111\u00f3 r\u00fat ng\u1eafn th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c. \u0110\u1eebng qu\u00ean theo d\u00f5i chuy\u00ean m\u1ee5c Kinh nghi\u1ec7m c\u1ee7a Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam c\u00e1c m\u1eb9o Excel v\u00e0 th\u1ee7 thu\u1eadt v\u0103n ph\u00f2ng h\u1eefu \u00edch.<\/p>\n

                  N\u1ebfu b\u1ea1n th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi Excel, m\u1ed9t chi\u1ebfc m\u00e1y t\u00ednh b\u1ea3ng ho\u1eb7c \u0111i\u1ec7n tho\u1ea1i c\u1ea5u h\u00ecnh m\u1ea1nh s\u1ebd gi\u00fap thao t\u00e1c nhanh v\u00e0 linh ho\u1ea1t h\u01a1n. Kh\u00e1m ph\u00e1 ngay c\u00e1c s\u1ea3n ph\u1ea9m ch\u00ednh h\u00e3ng, \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 t\u1ed1i \u01b0u c\u00f4ng vi\u1ec7c m\u1ed7i ng\u00e0y.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                  \u00a0 \u0110\u1ec3 r\u00fat ng\u1eafn c\u00e1c thao t\u00e1c t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u trong Excel, h\u00e0m SUMPRODUCT l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 mang l\u1ea1i hi\u1ec7u qu\u1ea3 r\u00f5 r\u1ec7t. H\u00e0m cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n m\u00e0 kh\u00f4ng c\u1ea7n t\u1ea1o th\u00eam c\u1ed9t ph\u1ee5, gi\u00fap b\u1ea3ng t\u00ednh r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 qu\u1ea3n […]<\/p>\n","protected":false},"author":1,"featured_media":5226,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-5225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat"],"jetpack_featured_media_url":"https:\/\/autofillform.com\/blog\/wp-content\/uploads\/2025\/11\/19451.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/comments?post=5225"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/5225\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/5226"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=5225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=5225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=5225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}