{"id":4848,"date":"2025-11-19T13:15:07","date_gmt":"2025-11-19T06:15:07","guid":{"rendered":"https:\/\/autofillform.com\/blog\/ham-aggregate-trong-excel-la-gi-huong-dan-cach-dung\/"},"modified":"2025-11-19T13:15:07","modified_gmt":"2025-11-19T06:15:07","slug":"ham-aggregate-trong-excel-la-gi-huong-dan-cach-dung","status":"publish","type":"post","link":"https:\/\/autofillform.com\/blog\/ham-aggregate-trong-excel-la-gi-huong-dan-cach-dung\/","title":{"rendered":"H\u00e0m AGGREGATE trong Excel l\u00e0 g\u00ec? H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng"},"content":{"rendered":"
\n
\u00a0<\/div>\n

H\u00e0m AGGREGATE trong Excel gi\u00fap b\u1ea1n t\u00ednh to\u00e1n d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch linh ho\u1ea1t, k\u1ec3 c\u1ea3 khi c\u00f3 l\u1ed7i ho\u1eb7c h\u00e0ng \u1ea9n trong b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AGGREGATE theo t\u1eebng d\u1ea1ng c\u00f4ng th\u1ee9c, k\u00e8m v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 \u0111\u1ec3 b\u1ea1n d\u1ec5 hi\u1ec3u v\u00e0 \u00e1p d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.<\/p>\n

\"h\u00e0mC\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AGGREGATE trong Excel<\/em><\/p>\n

\n

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

H\u00e0m AGGREGATE trong Excel l\u00e0 m\u1ed9t h\u00e0m t\u1ed5ng h\u1ee3p \u0111a n\u0103ng, gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n nhi\u1ec1u ph\u00e9p t\u00ednh th\u1ed1ng k\u00ea v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u linh ho\u1ea1t. \u0110\u1eb7c bi\u1ec7t, h\u00e0m n\u00e0y t\u00edch h\u1ee3p 19 h\u00e0m t\u00ednh to\u00e1n kh\u00e1c nhau nh\u01b0 SUM, AVERAGE, COUNT, MAX, MIN v\u00e0 nhi\u1ec1u h\u00e0m n\u00e2ng cao, cho ph\u00e9p b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 lo\u1ea1i tr\u1eeb l\u1ed7i trong b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n

H\u00e0m AGGREGATE ho\u1ea1t \u0111\u1ed9ng nh\u01b0 m\u1ed9t b\u1ed9 l\u1ecdc th\u00f4ng minh, cho ph\u00e9p b\u1ea1n lo\u1ea1i tr\u1eeb c\u00e1c gi\u00e1 tr\u1ecb l\u1ed7i, h\u00e0ng \u1ea9n ho\u1eb7c c\u00f4ng th\u1ee9c l\u1ed3ng nhau khi t\u00ednh to\u00e1n. Nh\u1edd \u0111\u00f3, k\u1ebft qu\u1ea3 lu\u00f4n ch\u00ednh x\u00e1c v\u00e0 \u1ed5n \u0111\u1ecbnh ngay c\u1ea3 v\u1edbi c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p.<\/p>\n

\"giaoGi\u1edbi thi\u1ec7u h\u00e0m AGGREGATE trong Excel v\u00e0 \u1ee9ng d\u1ee5ng th\u1ef1c t\u1ebf<\/em><\/p>\n

\n

2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AGGREGATE trong Excel<\/h2>\n<\/div>\n
\n

2.1. C\u00f4ng th\u1ee9c h\u00e0m AGGREGATE<\/h3>\n<\/div>\n

H\u00e0m AGGREGATE trong Excel c\u00f3 hai c\u00e1ch d\u00f9ng ch\u00ednh: d\u1ea1ng tham chi\u1ebfu v\u00e0 d\u1ea1ng m\u1ea3ng, m\u1ed7i d\u1ea1ng ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c \u0111\u00edch t\u00ednh to\u00e1n kh\u00e1c nhau.<\/p>\n

2.1.1. D\u1ea1ng tham chi\u1ebfu:<\/strong><\/h4>\n

=AGGREGATE(function_num, options, ref1, [ref2], \u2026)<\/p>\n

D\u00f9ng khi d\u1eef li\u1ec7u n\u1eb1m trong c\u00e1c v\u00f9ng ph\u1ea1m vi c\u1ed1 \u0111\u1ecbnh (range), ph\u00f9 h\u1ee3p cho c\u00e1c ph\u00e9p t\u00ednh c\u01a1 b\u1ea3n nh\u01b0 SUM, AVERAGE, MAX, MIN.<\/p>\n

2.1.2. D\u1ea1ng m\u1ea3ng:<\/strong><\/h4>\n

=AGGREGATE(function_num, options, array, [k])<\/p>\n

Ph\u00f9 h\u1ee3p \u0111\u1ec3 x\u1eed l\u00fd bi\u1ec3u th\u1ee9c m\u1ea3ng, d\u1eef li\u1ec7u t\u1ea1o b\u1edfi c\u00f4ng th\u1ee9c, ho\u1eb7c khi c\u1ea7n d\u00f9ng c\u00e1c h\u00e0m y\u00eau c\u1ea7u tham s\u1ed1 k nh\u01b0 LARGE, SMALL, PERCENTILE.<\/p>\n

\"danhC\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m AGGREGATE trong Excel<\/em><\/p>\n

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

    \n
  • function_num (b\u1eaft bu\u1ed9c):<\/strong> Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb 1\u201319 t\u01b0\u01a1ng \u1ee9ng v\u1edbi lo\u1ea1i ph\u00e9p t\u00ednh c\u1ea7n th\u1ef1c hi\u1ec7n.<\/li>\n
  • options (b\u1eaft bu\u1ed9c):<\/strong> Ch\u1ecdn gi\u00e1 tr\u1ecb t\u1eeb 0\u20137 \u0111\u1ec3 quy \u0111\u1ecbnh c\u00e1ch x\u1eed l\u00fd h\u00e0ng \u1ea9n, l\u1ed7i ho\u1eb7c c\u00f4ng th\u1ee9c l\u1ed3ng nhau.<\/li>\n
  • ref1 (b\u1eaft bu\u1ed9c):<\/strong> Ph\u1ea1m vi ho\u1eb7c \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n.<\/li>\n
  • ref2,\u2026 (t\u00f9y ch\u1ecdn):<\/strong> C\u00e1c ph\u1ea1m vi ho\u1eb7c \u0111\u1ed1i s\u1ed1 b\u1ed5 sung, t\u1ed1i \u0111a 253 v\u00f9ng.<\/li>\n
  • array (b\u1eaft bu\u1ed9c):<\/strong> M\u1ea3ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh to\u00e1n (\u00e1p d\u1ee5ng cho d\u1ea1ng m\u1ea3ng).<\/li>\n
  • k (t\u00f9y ch\u1ecdn):<\/strong> Gi\u00e1 tr\u1ecb th\u1ee9 t\u1ef1 d\u00f9ng cho m\u1ed9t s\u1ed1 h\u00e0m nh\u01b0 LARGE ho\u1eb7c SMALL.<\/li>\n<\/ul>\n
    \n

    2.2. B\u1ea3ng function_num trong h\u00e0m AGGREGATE<\/h3>\n<\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
    function_num<\/th>\nH\u00e0m t\u00ednh to\u00e1n<\/th>\nCh\u1ee9c n\u0103ng<\/th>\n<\/tr>\n<\/thead>\n
    1<\/td>\nAVERAGE<\/td>\nT\u00ednh trung b\u00ecnh c\u1ed9ng<\/td>\n<\/tr>\n
    2<\/td>\nCOUNT<\/td>\n\u0110\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a s\u1ed1<\/td>\n<\/tr>\n
    3<\/td>\nCOUNTA<\/td>\n\u0110\u1ebfm s\u1ed1 \u00f4 kh\u00f4ng tr\u1ed1ng<\/td>\n<\/tr>\n
    4<\/td>\nMAX<\/td>\nTr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t<\/td>\n<\/tr>\n
    5<\/td>\nMIN<\/td>\nTr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t<\/td>\n<\/tr>\n
    6<\/td>\nPRODUCT<\/td>\nNh\u00e2n t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi<\/td>\n<\/tr>\n
    7<\/td>\nSTDEV.S<\/td>\nT\u00ednh \u0111\u1ed9 l\u1ec7ch chu\u1ea9n m\u1eabu<\/td>\n<\/tr>\n
    8<\/td>\nSTDEV.P<\/td>\nT\u00ednh \u0111\u1ed9 l\u1ec7ch chu\u1ea9n t\u1ed5ng th\u1ec3<\/td>\n<\/tr>\n
    9<\/td>\nSUM<\/td>\nT\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb<\/td>\n<\/tr>\n
    10<\/td>\nVAR.S<\/td>\nT\u00ednh ph\u01b0\u01a1ng sai m\u1eabu<\/td>\n<\/tr>\n
    11<\/td>\nVAR.P<\/td>\nT\u00ednh ph\u01b0\u01a1ng sai t\u1ed5ng th\u1ec3<\/td>\n<\/tr>\n
    12<\/td>\nMEDIAN<\/td>\nTr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb trung v\u1ecb<\/td>\n<\/tr>\n
    13<\/td>\nMODE.SNGL<\/td>\nTr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb xu\u1ea5t hi\u1ec7n nhi\u1ec1u nh\u1ea5t<\/td>\n<\/tr>\n
    14<\/td>\nLARGE<\/td>\nTr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn th\u1ee9 n<\/td>\n<\/tr>\n
    15<\/td>\nSMALL<\/td>\nTr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf th\u1ee9 n<\/td>\n<\/tr>\n
    16<\/td>\nPERCENTILE.INC<\/td>\nT\u00ednh ph\u00e2n v\u1ecb th\u1ee9 k (bao g\u1ed3m 0 v\u00e0 1)<\/td>\n<\/tr>\n
    17<\/td>\nQUARTILE.INC<\/td>\nT\u00ednh t\u1ee9 ph\u00e2n v\u1ecb th\u1ee9 k (bao g\u1ed3m 0 v\u00e0 1)<\/td>\n<\/tr>\n
    18<\/td>\nPERCENTILE.EXC<\/td>\nT\u00ednh ph\u00e2n v\u1ecb th\u1ee9 k (kh\u00f4ng bao g\u1ed3m 0 v\u00e0 1)<\/td>\n<\/tr>\n
    19<\/td>\nQUARTILE.EXC<\/td>\nT\u00ednh t\u1ee9 ph\u00e2n v\u1ecb th\u1ee9 k (kh\u00f4ng bao g\u1ed3m 0 v\u00e0 1)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    \n

    2.3. B\u1ea3ng options trong h\u00e0m AGGREGATE<\/h3>\n<\/div>\n\n\n\n\n\n\n\n\n\n\n\n\n
    Options<\/th>\n\u00dd ngh\u0129a<\/th>\n<\/tr>\n<\/thead>\n
    0<\/td>\nB\u1ecf qua c\u00e1c \u00f4 ch\u1ee9a h\u00e0m SUBTOTAL v\u00e0 AGGREGATE<\/td>\n<\/tr>\n
    1<\/td>\nB\u1ecf qua h\u00e0ng \u1ea9n v\u00e0 c\u00e1c \u00f4 ch\u1ee9a h\u00e0m SUBTOTAL, AGGREGATE<\/td>\n<\/tr>\n
    2<\/td>\nB\u1ecf qua gi\u00e1 tr\u1ecb l\u1ed7i v\u00e0 c\u00e1c \u00f4 ch\u1ee9a h\u00e0m SUBTOTAL, AGGREGATE<\/td>\n<\/tr>\n
    3<\/td>\nB\u1ecf qua c\u1ea3 h\u00e0ng \u1ea9n, gi\u00e1 tr\u1ecb l\u1ed7i v\u00e0 c\u00e1c \u00f4 ch\u1ee9a h\u00e0m SUBTOTAL, AGGREGATE<\/td>\n<\/tr>\n
    4<\/td>\nT\u00ednh to\u00e1n to\u00e0n b\u1ed9 d\u1eef li\u1ec7u, kh\u00f4ng b\u1ecf qua b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o<\/td>\n<\/tr>\n
    5<\/td>\nB\u1ecf qua h\u00e0ng \u1ea9n nh\u01b0ng v\u1eabn t\u00ednh gi\u00e1 tr\u1ecb l\u1ed7i v\u00e0 h\u00e0m SUBTOTAL, AGGREGATE<\/td>\n<\/tr>\n
    6<\/td>\nB\u1ecf qua gi\u00e1 tr\u1ecb l\u1ed7i nh\u01b0ng v\u1eabn t\u00ednh h\u00e0ng \u1ea9n v\u00e0 c\u00e1c h\u00e0m SUBTOTAL, AGGREGATE<\/td>\n<\/tr>\n
    7<\/td>\nB\u1ecf qua c\u1ea3 h\u00e0ng \u1ea9n v\u00e0 gi\u00e1 tr\u1ecb l\u1ed7i nh\u01b0ng v\u1eabn t\u00ednh h\u00e0m SUBTOTAL, AGGREGATE<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
    Xem th\u00eam: <\/strong>H\u00e0m CODE trong Excel: C\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 l\u1ea5y m\u00e3 CODE<\/div>\n
    \n

    3. V\u00ed d\u1ee5 v\u1ec1 h\u00e0m AGGREGATE trong Excel<\/h2>\n<\/div>\n

    V\u00ed d\u1ee5 1: T\u00ednh t\u1ed5ng v\u00e0 b\u1ecf qua l\u1ed7i<\/strong><\/p>\n

    N\u1ebfu mu\u1ed1n t\u00ednh t\u1ed5ng nh\u01b0ng kh\u00f4ng b\u1ecb \u1ea3nh h\u01b0\u1edfng b\u1edfi c\u00e1c \u00f4 ch\u1ee9a l\u1ed7i, h\u00e3y s\u1eed d\u1ee5ng h\u00e0m AGGREGATE v\u1edbi t\u00f9y ch\u1ecdn 6 (b\u1ecf qua l\u1ed7i trong v\u00f9ng d\u1eef li\u1ec7u).<\/p>\n

    C\u00f4ng th\u1ee9c<\/strong>: =AGGREGATE(9,6,B2:B12)<\/p>\n

    K\u1ebft qu\u1ea3:<\/strong> 560 (ch\u1ec9 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7 trong ph\u1ea1m vi).<\/p>\n

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

      \n
    • 9 \u2192 \u0111\u1ea1i di\u1ec7n cho h\u00e0m SUM trong AGGREGATE.<\/li>\n
    • 6 \u2192 b\u1ecf qua c\u00e1c \u00f4 ch\u1ee9a l\u1ed7i.<\/li>\n
    • B2:B12 \u2192 ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng.<\/li>\n<\/ul>\n

      \"v\u00edD\u00f9ng h\u00e0m AGGREGATE t\u00ednh t\u1ed5ng b\u1ecf qua l\u1ed7i trong Excel<\/em><\/p>\n

      V\u00ed d\u1ee5 2: T\u00ednh t\u1ed5ng nh\u01b0ng kh\u00f4ng b\u1ecf qua l\u1ed7i<\/strong><\/p>\n

      N\u1ebfu b\u1ea1n kh\u00f4ng thi\u1ebft l\u1eadp t\u00f9y ch\u1ecdn b\u1ecf qua l\u1ed7i (ch\u1ecdn 4), ch\u1ec9 c\u1ea7n trong v\u00f9ng d\u1eef li\u1ec7u c\u00f3 m\u1ed9t \u00f4 b\u1ecb l\u1ed7i th\u00ec to\u00e0n b\u1ed9 k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u0169ng s\u1ebd l\u00e0 l\u1ed7i.<\/p>\n

      C\u00f4ng th\u1ee9c:<\/strong> =AGGREGATE(9,4,B2:B12)<\/p>\n

      K\u1ebft qu\u1ea3: <\/strong>#DIV\/0! (ho\u1eb7c l\u1ed7i t\u01b0\u01a1ng t\u1ef1), v\u00ec v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a c\u00e1c \u00f4 l\u1ed7i nh\u01b0 #DIV\/0!, #VALUE!, #NUM!, v\u00e0 t\u00f9y ch\u1ecdn 4 kh\u00f4ng b\u1ecf qua l\u1ed7i trong ph\u00e9p t\u00ednh.<\/p>\n

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

        \n
      • 9 \u2192 th\u1ef1c hi\u1ec7n ph\u00e9p SUM.<\/li>\n
      • 4 \u2192 t\u00ednh c\u1ea3 c\u00e1c \u00f4 l\u1ed7i, d\u1eabn \u0111\u1ebfn c\u00f4ng th\u1ee9c b\u1ecb l\u1ed7i.<\/li>\n
      • B2:B12 \u2192 v\u00f9ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a l\u1ed7i (#DIV\/0!, #VALUE!, #NUM!).<\/li>\n<\/ul>\n

        \"v\u00edT\u00ednh t\u1ed5ng nh\u01b0ng kh\u00f4ng b\u1ecf qua l\u1ed7i trong v\u00f9ng d\u1eef li\u1ec7u<\/em><\/p>\n

        V\u00ed d\u1ee5 3: T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 b\u1ecf qua l\u1ed7i<\/strong><\/p>\n

        Khi mu\u1ed1n x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong v\u00f9ng d\u1eef li\u1ec7u nh\u01b0ng m\u1ed9t s\u1ed1 \u00f4 ch\u1ee9a l\u1ed7i (#DIV\/0!, #VALUE!, #NUM!), ta c\u00f3 th\u1ec3 d\u00f9ng t\u00f9y ch\u1ecdn 6 \u0111\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng b\u1ecf qua c\u00e1c l\u1ed7i \u0111\u00f3 v\u00e0 ch\u1ec9 t\u00ednh tr\u00ean c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7.<\/p>\n

        C\u00f4ng th\u1ee9c:<\/strong> =AGGREGATE(4,6,B2:B12)<\/p>\n

        K\u1ebft qu\u1ea3:<\/strong> 92 (h\u00e0m t\u1ef1 b\u1ecf qua c\u00e1c \u00f4 l\u1ed7i v\u00e0 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t h\u1ee3p l\u1ec7 trong v\u00f9ng d\u1eef li\u1ec7u).<\/p>\n

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

          \n
        • 4 \u2192 \u0111\u1ea1i di\u1ec7n cho h\u00e0m MAX trong AGGREGATE.<\/li>\n
        • 6 \u2192 t\u00f9y ch\u1ecdn b\u1ecf qua l\u1ed7i.<\/li>\n
        • B2:B12 \u2192 ph\u1ea1m vi ch\u1ee9a d\u1eef li\u1ec7u c\u1ea7n t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/li>\n<\/ul>\n

          \"t\u00ecmT\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t b\u1eb1ng h\u00e0m AGGREGATE v\u00e0 b\u1ecf qua l\u1ed7i<\/em><\/p>\n

          V\u00ed d\u1ee5 4: T\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh v\u00e0 b\u1ecf qua l\u1ed7i<\/strong><\/p>\n

          Khi mu\u1ed1n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a v\u00f9ng d\u1eef li\u1ec7u nh\u01b0ng c\u00f3 m\u1ed9t s\u1ed1 \u00f4 b\u1ecb l\u1ed7i (#DIV\/0!, #VALUE!, #NUM!), ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m AGGREGATE v\u1edbi t\u00f9y ch\u1ecdn 6 \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c gi\u00e1 tr\u1ecb l\u1ed7i v\u00e0 ch\u1ec9 l\u1ea5y d\u1eef li\u1ec7u h\u1ee3p l\u1ec7.<\/p>\n

          C\u00f4ng th\u1ee9c:<\/strong> =AGGREGATE(1,6,B2:B12)<\/p>\n

          K\u1ebft qu\u1ea3: <\/strong>70 (h\u00e0m t\u00ednh trung b\u00ecnh c\u00e1c gi\u00e1 tr\u1ecb h\u1ee3p l\u1ec7: 85, 92, 60, 73, 40, 55, 65, 90).<\/p>\n

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

            \n
          • 1 \u2192 \u0111\u1ea1i di\u1ec7n cho h\u00e0m AVERAGE trong danh s\u00e1ch h\u00e0m c\u1ee7a AGGREGATE.<\/li>\n
          • 6 \u2192 t\u00f9y ch\u1ecdn b\u1ecf qua c\u00e1c gi\u00e1 tr\u1ecb l\u1ed7i.<\/li>\n
          • B2:B12 \u2192 ph\u1ea1m vi d\u1eef li\u1ec7u c\u1ea7n t\u00ednh trung b\u00ecnh.<\/li>\n<\/ul>\n

            \"v\u00edT\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh b\u1eb1ng h\u00e0m AGGREGATE trong Excel<\/em><\/p>\n

            \n

            4. L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m AGGREGATE<\/h2>\n<\/div>\n

            \u0110\u1ec3 h\u00e0m AGGREGATE ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c v\u00e0 hi\u1ec7u qu\u1ea3, c\u1ea7n ghi nh\u1edb m\u1ed9t s\u1ed1 \u0111i\u1ec3m sau:<\/p>\n

              \n
            • Khi g\u00f5 =AGGREGATE(<\/strong>, Excel s\u1ebd hi\u1ec3n th\u1ecb danh s\u00e1ch function_num (t\u1eeb 1\u201319)<\/strong> \u0111\u1ec3 ch\u1ecdn. Sau khi ch\u1ecdn xong v\u00e0 nh\u1eadp d\u1ea5u ph\u1ea9y, danh s\u00e1ch options s\u1ebd xu\u1ea5t hi\u1ec7n gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh \u0111i\u1ec1u ki\u1ec7n lo\u1ea1i tr\u1eeb l\u1ed7i ho\u1eb7c h\u00e0ng \u1ea9n.<\/li>\n
            • N\u1ebfu b\u1ecf s\u00f3t \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c nh\u01b0 ref1<\/strong> ho\u1eb7c array<\/strong>, h\u00e0m s\u1ebd b\u00e1o l\u1ed7i #VALUE!<\/strong>. H\u00e3y \u0111\u1ea3m b\u1ea3o nh\u1eadp \u0111\u1ea7y \u0111\u1ee7 tham s\u1ed1 c\u1ea7n thi\u1ebft.<\/li>\n
            • H\u00e0m AGGREGATE ch\u1ec9 h\u1ed7 tr\u1ee3 ph\u1ea1m vi trong m\u1ed9t b\u1ea3ng t\u00ednh duy nh\u1ea5t, kh\u00f4ng \u00e1p d\u1ee5ng cho tham chi\u1ebfu 3D (v\u00ed d\u1ee5: Sheet1:Sheet3!A1:A10).<\/li>\n
            • H\u00e0m ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u0111\u1ecbnh nh\u1ea5t khi \u00e1p d\u1ee5ng cho d\u1eef li\u1ec7u theo c\u1ed9t. N\u1ebfu d\u00f9ng tr\u00ean h\u00e0ng ngang, k\u1ebft qu\u1ea3 c\u00f3 th\u1ec3 sai ho\u1eb7c ph\u00e1t sinh l\u1ed7i ngo\u00e0i \u00fd mu\u1ed1n.<\/li>\n<\/ul>\n

              H\u00e0m AGGREGATE gi\u00fap b\u1ea1n t\u1ed1i \u01b0u vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p trong Excel, \u0111\u1eb7c bi\u1ec7t khi c\u1ea7n lo\u1ea1i b\u1ecf l\u1ed7i ho\u1eb7c h\u00e0ng \u1ea9n. \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 nhi\u1ec1u m\u1eb9o v\u00e0 h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Excel hi\u1ec7u qu\u1ea3 h\u01a1n m\u1ed7i ng\u00e0y.<\/p>\n

              B\u1ea1n c\u00f3 th\u1ec3 thao t\u00e1c nhanh v\u00e0 l\u00e0m vi\u1ec7c ti\u1ec7n l\u1ee3i h\u01a1n v\u1edbi c\u00e1c m\u1eabu m\u00e1y t\u00ednh b\u1ea3ng hi\u1ec7u n\u0103ng cao, m\u00e0n h\u00ecnh l\u1edbn, h\u1ed7 tr\u1ee3 Excel m\u01b0\u1ee3t m\u00e0. Tham kh\u1ea3o ngay t\u1ea1i Si\u00eau Th\u1ecb \u0110i\u1ec7n M\u00e1y – N\u1ed9i Th\u1ea5t Ch\u1ee3 L\u1edbn \u0111\u1ec3 ch\u1ecdn thi\u1ebft b\u1ecb ph\u00f9 h\u1ee3p cho h\u1ecdc t\u1eadp v\u00e0 c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              \u00a0 H\u00e0m AGGREGATE trong Excel gi\u00fap b\u1ea1n t\u00ednh to\u00e1n d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch linh ho\u1ea1t, k\u1ec3 c\u1ea3 khi c\u00f3 l\u1ed7i ho\u1eb7c h\u00e0ng \u1ea9n trong b\u1ea3ng t\u00ednh. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m AGGREGATE theo t\u1eebng d\u1ea1ng c\u00f4ng th\u1ee9c, k\u00e8m v\u00ed d\u1ee5 c\u1ee5 th\u1ec3 \u0111\u1ec3 b\u1ea1n d\u1ec5 hi\u1ec3u v\u00e0 \u00e1p d\u1ee5ng v\u00e0o […]<\/p>\n","protected":false},"author":1,"featured_media":4849,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-4848","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\/19366.jpg","_links":{"self":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4848","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=4848"}],"version-history":[{"count":0,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/posts\/4848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media\/4849"}],"wp:attachment":[{"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/media?parent=4848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/categories?post=4848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/autofillform.com\/blog\/wp-json\/wp\/v2\/tags?post=4848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}