{"id":385446,"date":"2024-09-15T10:57:04","date_gmt":"2024-09-15T03:57:04","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=385446"},"modified":"2024-09-15T10:57:04","modified_gmt":"2024-09-15T03:57:04","slug":"ham-thong-ke-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m th\u1ed1ng k\u00ea l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn v\u1edbi c\u00e1ch d\u00f9ng kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p nh\u01b0ng s\u1ebd g\u00e2y s\u1ef1 nh\u1ea7m l\u1eabn cho nh\u1eefng ng\u01b0\u1eddi m\u1edbi l\u00e0m quen v\u1edbi ph\u1ea7n m\u1ec1m. Do \u0111\u00f3, b\u1ea1n c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a c\u00e1c h\u00e0m th\u1ed1ng k\u00ea v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1ec5 d\u00e0ng t\u00ednh to\u00e1n v\u00e0 th\u1ed1ng k\u00ea. Th\u00f4ng qua b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Ho\u00e0ng H\u00e0 Mobile s\u1ebd t\u1ed5ng h\u1ee3p c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t v\u00e0 c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda \u0111\u1ec3 b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">H\u00e0m th\u1ed1ng k\u00ea trong Excel l\u00e0 g\u00ec?\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Trong Excel, h\u00e0m th\u1ed1ng k\u00ea l\u00e0 c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 gi\u00fap b\u1ea1n ph\u00e2n t\u00edch v\u00e0 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 d\u1eef li\u1ec7u c\u1ee7a m\u00ecnh. N\u00f3 cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n nhi\u1ec1u t\u00e1c v\u1ee5 kh\u00e1c nhau, t\u1eeb nh\u1eefng t\u00ednh to\u00e1n \u0111\u01a1n gi\u1ea3n nh\u01b0 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng hay t\u00ednh t\u1ed5ng, cho \u0111\u1ebfn nh\u1eefng ph\u00e2n t\u00edch ph\u1ee9c t\u1ea1p h\u01a1n nh\u01b0 t\u00ecm gi\u00e1 tr\u1ecb trung b\u00ecnh, \u0111\u1ed9 l\u1ec7ch chu\u1ea9n, hay th\u1eadm ch\u00ed d\u1ef1 \u0111o\u00e1n xu h\u01b0\u1edbng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-385470 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1.jpg\" alt=\"ham-thong-ke-trong-excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">V\u00ec sao n\u00ean s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u00ea Excel l\u00e0 r\u1ea5t quan tr\u1ecdng \u0111\u1ec3 x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, t\u1eeb \u0111\u00f3 h\u1ed7 tr\u1ee3 qu\u00e1 tr\u00ecnh ra quy\u1ebft \u0111\u1ecbnh v\u00e0 \u0111\u1ea1t \u0111\u01b0\u1ee3c m\u1ee5c ti\u00eau c\u00f4ng vi\u1ec7c.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c: Thay v\u00ec ph\u1ea3i t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng, c\u00e1c h\u00e0m th\u1ed1ng k\u00ea cho ph\u00e9p b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c tr\u00ean m\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">T\u0103ng t\u00ednh ch\u00ednh x\u00e1c: Gi\u1ea3m thi\u1ec3u sai s\u00f3t do t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng, \u0111\u1eb7c bi\u1ec7t khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u l\u1edbn.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Ph\u00e2n t\u00edch d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3: C\u00e1c h\u00e0m th\u1ed1ng k\u00ea cung c\u1ea5p th\u00f4ng tin chi ti\u1ebft v\u1ec1 d\u1eef li\u1ec7u, gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 xu h\u01b0\u1edbng, ph\u00e2n b\u1ed1, v\u00e0 c\u00e1c \u0111\u1eb7c \u0111i\u1ec3m kh\u00e1c c\u1ee7a d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u01b0a ra quy\u1ebft \u0111\u1ecbnh s\u00e1ng su\u1ed1t: D\u1ef1a tr\u00ean c\u00e1c ph\u00e2n t\u00edch th\u1ed1ng k\u00ea, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean b\u1eb1ng ch\u1ee9ng v\u00e0 th\u00f4ng tin c\u1ee5 th\u1ec3.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u chuy\u00ean nghi\u1ec7p: Excel cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 \u0111\u1ec3 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u th\u1ed1ng k\u00ea, gi\u00fap b\u1ea1n t\u1ea1o c\u00e1c bi\u1ec3u \u0111\u1ed3 v\u00e0 b\u00e1o c\u00e1o chuy\u00ean nghi\u1ec7p.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-385471 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2.jpg\" alt=\"ham-thong-ke-trong-excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">H\u01b0\u1edbng d\u1eabn c\u00e1ch d\u00f9ng h\u00e0m th\u1ed1ng k\u00ea trong Excel nhanh ch\u00f3ng v\u00e0 \u0111\u01a1n gi\u1ea3n\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1edbi m\u1ed7i m\u1ee5c \u0111\u00edch kh\u00e1c nhau, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u1ed1ng k\u1ebf kh\u00e1c nhau trong Excel \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh to\u00e1n.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m COUNT\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u \u0111\u00f3 ch\u00ednh l\u00e0 h\u00e0m Count. \u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u00e3 \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng trong m\u1ed9t v\u00f9ng ho\u1eb7c 1 b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn tr\u01b0\u1edbc \u0111\u00f3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u00f3 l\u00e0 =COUNT (gi\u00e1 tr\u1ecb 1,[gi\u00e1 tr\u1ecb 2],&#8230;). Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">gi\u00e1 tr\u1ecb 1: \u0110\u00e2y l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t \u00f4 c\u1ee5 th\u1ec3, m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c m\u1ed9t m\u1ea3ng gi\u00e1 tr\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">gi\u00e1 tr\u1ecb 2: \u0110\u00e2y l\u00e0 c\u00e1c tham s\u1ed1 t\u00f9y ch\u1ecdn, cho ph\u00e9p b\u1ea1n ch\u1ec9 \u0111\u1ecbnh th\u00eam c\u00e1c \u00f4, v\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c m\u1ea3ng gi\u00e1 tr\u1ecb kh\u00e1c \u0111\u1ec3 \u0111\u1ebfm.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNT ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch duy\u1ec7t qua t\u1eebng gi\u00e1 tr\u1ecb trong c\u00e1c tham s\u1ed1 \u0111\u00e3 cho. N\u1ebfu gi\u00e1 tr\u1ecb \u0111\u00f3 l\u00e0 m\u1ed9t s\u1ed1, n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh v\u00e0o t\u1ed5ng s\u1ed1 \u0111\u1ebfm. C\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng ph\u1ea3i s\u1ed1, bao g\u1ed3m c\u1ea3 v\u0103n b\u1ea3n, ng\u00e0y th\u00e1ng, gi\u00e1 tr\u1ecb logic v\u00e0 \u00f4 tr\u1ed1ng, th\u00ec s\u1ebd b\u1ecb b\u1ecf qua.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-385473 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4.jpg\" alt=\"ham-thong-ke-trong-excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m COUNTIF<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNTIF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea trong Excel cho ph\u00e9p b\u1ea1n \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e1p \u1ee9ng m\u1ed9t ti\u00eau ch\u00ed c\u1ee5 th\u1ec3. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea h\u1eefu \u00edch, th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 t\u00f3m t\u1eaft d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m COUNTIF kh\u00e1 \u0111\u01a1n gi\u1ea3n: =COUNTIF (range, criteria). Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra. \u0110\u00e2y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t d\u1ea3i \u00f4 li\u1ec1n k\u1ec1 ho\u1eb7c m\u1ed9t nh\u00f3m \u00f4 kh\u00f4ng li\u00ean t\u1ee5c.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria bi\u1ec3u di\u1ec5n \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm. Ti\u00eau ch\u00ed n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n, m\u1ed9t bi\u1ec3u th\u1ee9c logic ho\u1eb7c m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 kh\u00e1c.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385453 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6.jpg\" alt=\"ham-thong-ke-trong-excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m COUNTIFS<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">COUNTIFS l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng \u00f4 th\u1ecfa m\u00e3n m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u00e3 cho. C\u00e1c \u0111i\u1ec1u ki\u1ec7n n\u00e0y c\u00f3 th\u1ec3 ki\u1ec3m tra xem gi\u00e1 tr\u1ecb trong \u00f4 c\u00f3 b\u1eb1ng m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3, l\u1edbn h\u01a1n hay nh\u1ecf h\u01a1n m\u1ed9t gi\u00e1 tr\u1ecb kh\u00e1c, ho\u1eb7c n\u1eb1m trong m\u1ed9t kho\u1ea3ng x\u00e1c \u0111\u1ecbnh.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COUNTIFS \u0111\u00f3 l\u00e0 =COUNTIFS (Criteria_rang1,Criteria,[Criteria_range2,Criteria2],&#8230;). Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria_range1: V\u00f9ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean c\u1ea7n ki\u1ec3m tra.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria1: Ti\u00eau ch\u00ed \u00e1p d\u1ee5ng cho v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ea7u ti\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[Criteria_range2, Criteria2]\u2026: C\u00e1c c\u1eb7p v\u00f9ng d\u1eef li\u1ec7u v\u00e0 ti\u00eau ch\u00ed b\u1ed5 sung (t\u00f9y ch\u1ecdn).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385454 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7.jpg\" alt=\"ham-thong-ke-trong-excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m COUNTBLANK\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNTBLANK l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea ph\u1ed5 bi\u1ebfn trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 tr\u1ed1ng trong m\u1ed9t ph\u1ea1m vi \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea, cho ph\u00e9p ng\u01b0\u1eddi d\u00f9ng nhanh ch\u00f3ng \u0111\u00e1nh gi\u00e1 m\u1ee9c \u0111\u1ed9 ho\u00e0n thi\u1ec7n c\u1ee7a d\u1eef li\u1ec7u ho\u1eb7c x\u00e1c \u0111\u1ecbnh c\u00e1c khu v\u1ef1c c\u1ea7n nh\u1eadp li\u1ec7u b\u1ed5 sung.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1ec1 c\u00f4ng th\u1ee9c, h\u00e0m COUNTBLANK r\u1ea5t \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb: \u201c=COUNTBLANK(Range)\u201d. Trong \u0111\u00f3, Range l\u00e0 v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra c\u00e1c \u00f4 tr\u1ed1ng. Ph\u1ea1m vi n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t c\u1ed9t, m\u1ed9t h\u00e0ng, ho\u1eb7c m\u1ed9t v\u00f9ng ch\u1ecdn b\u1ea5t k\u1ef3 tr\u00ean b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNTBLANK ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch duy\u1ec7t qua t\u1eebng \u00f4 trong ph\u1ea1m vi \u0111\u00e3 cho. N\u1ebfu m\u1ed9t \u00f4 kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 gi\u00e1 tr\u1ecb n\u00e0o (bao g\u1ed3m c\u1ea3 kho\u1ea3ng tr\u1eafng), n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 m\u1ed9t \u00f4 tr\u1ed1ng. K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 c\u1ee7a h\u00e0m l\u00e0 t\u1ed5ng s\u1ed1 \u00f4 tr\u1ed1ng t\u00ecm th\u1ea5y.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385455 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8.jpg\" alt=\"ham-thong-ke-trong-excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m SUM<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t h\u00e0m th\u1ed1ng k\u00ea kh\u00e1c trong Excel ph\u1ed5 bi\u1ebfn \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng \u0111\u00f3 l\u00e0 h\u00e0m SUM \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i \u0111\u1ec3 t\u00ednh to\u00e1n t\u1ed5ng c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1. V\u1ec1 b\u1ea3n ch\u1ea5t, h\u00e0m SUM th\u1ef1c hi\u1ec7n ph\u00e9p c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c cung c\u1ea5p cho n\u00f3, cho ra k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng c\u1ee7a ch\u00fang.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SUM c\u1ef1c k\u1ef3 \u0111\u01a1n gi\u1ea3n v\u00e0 d\u1ec5 nh\u1edb \u0111\u00f3 l\u00e0 \u201c=SUM(s\u1ed1 1,[s\u1ed1 2],&#8230;). Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>s\u1ed1 1<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c \u0111\u1ea7u ti\u00ean, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1 c\u1ee5 th\u1ec3, m\u1ed9t tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1, ho\u1eb7c m\u1ed9t ph\u1ea1m vi \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><b>[s\u1ed1 2], &#8230;<\/b><span style=\"font-weight: 400;\">: \u0110\u00e2y l\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn, cho ph\u00e9p b\u1ea1n th\u00eam nhi\u1ec1u s\u1ed1 ho\u1eb7c ph\u1ea1m vi \u00f4 h\u01a1n \u0111\u1ec3 t\u00ednh t\u1ed5ng. H\u00e0m SUM ch\u1ec9 c\u00f3 th\u1ec3 x\u1eed l\u00fd t\u1ed1i \u0111a 255 \u0111\u1ed1i s\u1ed1.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385456 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9.jpg\" alt=\"ham-thong-ke-trong-excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m SUMIF<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m SUMIF l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea trong Excel c\u1ef1c k\u1ef3 ph\u1ed5 bi\u1ebfn, cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n, h\u00e0m SUMIF t\u00ecm ki\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n ti\u00eau ch\u00ed b\u1ea1n \u0111\u01b0a ra v\u00e0 ch\u1ec9 c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng v\u1edbi nh\u1eefng \u00f4 \u0111\u00f3. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m SUMIF nh\u01b0 sau \u201c=SUMIF(range, criteria, [sum_range])\u201d. Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Range bi\u1ec3u di\u1ec5n cho ph\u1ea1m vi \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Criteria l\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1ea1n mu\u1ed1n \u00e1p d\u1ee5ng, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, bi\u1ec3u th\u1ee9c, ho\u1eb7c tham chi\u1ebfu \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sum_Range (t\u00f9y ch\u1ecdn) l\u00e0 ph\u1ea1m vi \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n c\u1ed9ng. N\u1ebfu b\u1ecf tr\u1ed1ng, h\u00e0m s\u1ebd c\u1ed9ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385457 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10.jpg\" alt=\"ham-thong-ke-trong-excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m SUMIFS<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m SUMIFS l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea trong Excel cho ph\u00e9p b\u1ea1n t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. \u0110\u00e2y l\u00e0 m\u1ed9t b\u01b0\u1edbc ti\u1ebfn so v\u1edbi h\u00e0m SUMIF, ch\u1ec9 cho ph\u00e9p m\u1ed9t \u0111i\u1ec1u ki\u1ec7n duy nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">V\u1ec1 c\u01a1 b\u1ea3n, SUMIFS ho\u1ea1t \u0111\u1ed9ng b\u1eb1ng c\u00e1ch qu\u00e9t qua m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u, ki\u1ec3m tra xem li\u1ec7u m\u1ed7i h\u00e0ng c\u00f3 \u0111\u00e1p \u1ee9ng t\u1ea5t c\u1ea3 c\u00e1c ti\u00eau ch\u00ed \u0111\u00e3 ch\u1ec9 \u0111\u1ecbnh hay kh\u00f4ng. N\u1ebfu c\u00f3, gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t t\u00ednh t\u1ed5ng s\u1ebd \u0111\u01b0\u1ee3c th\u00eam v\u00e0o t\u1ed5ng cu\u1ed1i c\u00f9ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIFS nh\u01b0 sau \u201c=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)\u201d. Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">sum_range: Ph\u1ea1m vi ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ed5ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria_range1: Ph\u1ea1m vi c\u1ea7n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n \u0111\u1ea7u ti\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria1: \u0110i\u1ec1u ki\u1ec7n \u00e1p d\u1ee5ng cho criteria_range1.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria_range2, criteria2, &#8230; (t\u00f9y ch\u1ecdn): C\u00e1c c\u1eb7p ph\u1ea1m vi v\u00e0 \u0111i\u1ec1u ki\u1ec7n b\u1ed5 sung.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385458 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11.jpg\" alt=\"ham-thong-ke-trong-excel-11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-11-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m RANK<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea trong Excel cho ph\u00e9p b\u1ea1n s\u1eafp x\u1ebfp v\u00e0 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 \u0111\u00f3 l\u00e0 h\u00e0m RANK. Nh\u00ecn chung, h\u00e0m n\u00e0y x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed t\u01b0\u01a1ng \u0111\u1ed1i c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong m\u1ed9t danh s\u00e1ch c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u01a1n gi\u1ea3n h\u01a1n, n\u00f3 cho bi\u1ebft gi\u00e1 tr\u1ecb \u0111\u00f3 \u0111\u1ee9ng th\u1ee9 m\u1ea5y trong danh s\u00e1ch, x\u00e9t theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m RANK \u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi d\u1ea1ng \u201c=RANK(number, ref, [order])\u201d. Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">number: l\u00e0 gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n x\u00e1c \u0111\u1ecbnh th\u1ee9 h\u1ea1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">ref: Ph\u1ea1m vi ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1ec3 so s\u00e1nh v\u1edbi number.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[order]: (T\u00f9y ch\u1ecdn) Ch\u1ec9 \u0111\u1ecbnh th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp. N\u1ebfu order l\u00e0 0 ho\u1eb7c kh\u00f4ng \u0111\u01b0\u1ee3c nh\u1eadp, h\u00e0m s\u1ebd x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n (gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t c\u00f3 th\u1ee9 h\u1ea1ng l\u00e0 1). N\u1ebfu order l\u00e0 m\u1ed9t s\u1ed1 kh\u00e1c 0, h\u00e0m s\u1ebd x\u1ebfp h\u1ea1ng theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n (gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u00f3 th\u1ee9 h\u1ea1ng l\u00e0 1).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385459 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12.jpg\" alt=\"ham-thong-ke-trong-excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m AVERAGE<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m AVERAGE l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea quan tr\u1ecdng trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ed9ng r\u00e3i \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ed9ng c\u1ee7a m\u1ed9t t\u1eadp h\u1ee3p c\u00e1c s\u1ed1. V\u1ec1 c\u01a1 b\u1ea3n, h\u00e0m n\u00e0y th\u1ef1c hi\u1ec7n vi\u1ec7c c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c cung c\u1ea5p, sau \u0111\u00f3 chia t\u1ed5ng cho s\u1ed1 l\u01b0\u1ee3ng gi\u00e1 tr\u1ecb \u0111\u00f3. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m AVERAGE \u0111\u00f3 l\u00e0 =AVERAGE (number1, [number2],&#8230;). Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">number1 l\u00e0 \u0111\u1ed1i s\u1ed1 b\u1eaft bu\u1ed9c, \u0111\u1ea1i di\u1ec7n cho s\u1ed1 \u0111\u1ea7u ti\u00ean, tham chi\u1ebfu \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh trung b\u00ecnh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[number2], &#8230; l\u00e0 c\u00e1c \u0111\u1ed1i s\u1ed1 t\u00f9y ch\u1ecdn, cho ph\u00e9p b\u1ea1n th\u00eam t\u1ed1i \u0111a 255 s\u1ed1, tham chi\u1ebfu \u00f4 ho\u1eb7c v\u00f9ng d\u1eef li\u1ec7u kh\u00e1c v\u00e0o ph\u00e9p t\u00ednh trung b\u00ecnh.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385460 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13.jpg\" alt=\"ham-thong-ke-trong-excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m AVERAGEIF<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m AVERAGEIF trong Excel l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u1ebf cho ph\u00e9p b\u1ea1n t\u00ednh trung b\u00ecnh c\u1ed9ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, ngh\u0129a l\u00e0 ch\u1ec9 t\u00ednh trung b\u00ecnh c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n m\u1ed9t ti\u00eau ch\u00ed c\u1ee5 th\u1ec3 n\u00e0o \u0111\u00f3. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi b\u1ea1n c\u1ea7n ph\u00e2n t\u00edch d\u1eef li\u1ec7u theo m\u1ed9t g\u00f3c nh\u00ecn nh\u1ea5t \u0111\u1ecbnh ho\u1eb7c t\u1eadp trung v\u00e0o m\u1ed9t nh\u00f3m c\u1ee5 th\u1ec3 trong t\u1eadp d\u1eef li\u1ec7u l\u1edbn. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m AVERAGEIF nh\u01b0 sau \u201cAVERAGEIF (range, criteria,[average_range]). Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">range: Ph\u1ea1m vi \u00f4 c\u1ea7n ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria: Ti\u00eau ch\u00ed \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u00f4 n\u00e0o \u0111\u01b0\u1ee3c t\u00ednh trung b\u00ecnh. Ti\u00eau ch\u00ed n\u00e0y c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t s\u1ed1, m\u1ed9t bi\u1ec3u th\u1ee9c logic, ho\u1eb7c m\u1ed9t chu\u1ed7i v\u0103n b\u1ea3n.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[average_range]: (T\u00f9y ch\u1ecdn) Ph\u1ea1m vi \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh trung b\u00ecnh. N\u1ebfu b\u1ecf qua tham s\u1ed1 n\u00e0y, h\u00e0m s\u1ebd t\u00ednh trung b\u00ecnh c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi range.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385461 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14.jpg\" alt=\"ham-thong-ke-trong-excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m AVERAGEIFS<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m AVERAGEIFS l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea trong Excel cho ph\u00e9p b\u1ea1n t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t d\u1ea3i \u00f4 d\u1ef1a tr\u00ean nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. \u0110\u00e2y l\u00e0 m\u1ed9t phi\u00ean b\u1ea3n n\u00e2ng cao c\u1ee7a h\u00e0m AVERAGEIF, cho ph\u00e9p b\u1ea1n \u00e1p d\u1ee5ng nhi\u1ec1u ti\u00eau ch\u00ed l\u1ecdc thay v\u00ec ch\u1ec9 m\u1ed9t. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m AVERAGEIFS \u0111\u00f3 l\u00e0 &#8220;=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], &#8230;)&#8221;. Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">average_range: V\u00f9ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh trung b\u00ecnh.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria_range1: V\u00f9ng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n so s\u00e1nh v\u1edbi ti\u00eau ch\u00ed \u0111\u1ea7u ti\u00ean.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">criteria1: Ti\u00eau ch\u00ed \u0111\u1ea7u ti\u00ean \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">[criteria_range2, criteria2], &#8230;: C\u00e1c c\u1eb7p v\u00f9ng ti\u00eau ch\u00ed v\u00e0 ti\u00eau ch\u00ed b\u1ed5 sung (t\u00f9y ch\u1ecdn).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385462 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15.jpg\" alt=\"ham-thong-ke-trong-excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m MIN<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Min l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u1ecf nh\u1ea5t v\u1edbi gi\u00e1 tr\u1ecb trong v\u00f9ng ho\u1eb7c b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. H\u00e0m MIN \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u00f3 l\u00e0 \u201c=MIN (number 1, number 2,&#8230;) v\u1edbi c\u00e1c number1, number ch\u1ee9a gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u00f4 c\u1ea7n t\u00ednh.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385463 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16.jpg\" alt=\"ham-thong-ke-trong-excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m MAX<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Tr\u00e1i ng\u01b0\u1ee3c v\u1edbi h\u00e0m MIN, MAX l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ki\u1ebfm k\u1ebft qu\u1ea3 l\u1edbn nh\u1ea5t c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb trong v\u00f9ng ho\u1eb7c b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ecdn. H\u00e0m MAX \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00f4ng th\u1ee9c \u0111\u00f3 l\u00e0 =MAX (number 1, number 2,&#8230;) v\u1edbi c\u00e1c number1, number ch\u1ee9a gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u c\u1ee7a nh\u1eefng \u00f4 c\u1ea7n t\u00ednh.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385464 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17.jpg\" alt=\"ham-thong-ke-trong-excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m ROW<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m ROW l\u00e0 m\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n v\u00e0 h\u1eefu \u00edch trong Excel, \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng trong vi\u1ec7c x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u. V\u1ec1 b\u1ea3n ch\u1ea5t, h\u00e0m ROW tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng m\u00e0 m\u1ed9t \u00f4 c\u1ee5 th\u1ec3 \u0111ang n\u1eb1m trong b\u1ea3ng t\u00ednh.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROW kh\u00e1 \u0111\u01a1n gi\u1ea3n \u0111\u00f3 l\u00e0 =ROW([reference]). Trong \u0111\u00f3, reference l\u00e0 tham chi\u1ebfu t\u00f9y ch\u1ecdn \u0111\u1ebfn m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u. N\u1ebfu kh\u00f4ng cung c\u1ea5p reference, h\u00e0m s\u1ebd m\u1eb7c \u0111\u1ecbnh tr\u1ea3 v\u1ec1 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng ch\u1ee9a ch\u00ednh c\u00f4ng th\u1ee9c \u0111\u00f3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385465 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18.jpg\" alt=\"ham-thong-ke-trong-excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m ROWS<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m ROWS l\u00e0 m\u1ed9t h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m \u0111\u01a1n gi\u1ea3n nh\u01b0ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian \u0111\u00e1ng k\u1ec3 khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh l\u1edbn v\u00e0 ph\u1ee9c t\u1ea1p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m ROWS tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u00f3 trong m\u1ed9t m\u1ea3ng ho\u1eb7c m\u1ed9t v\u00f9ng tham chi\u1ebfu. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh c\u00f3 bao nhi\u00eau h\u00e0ng d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng t\u00ednh, m\u1ed9t c\u1ed9t, ho\u1eb7c th\u1eadm ch\u00ed m\u1ed9t v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn ng\u1eabu nhi\u00ean.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m ROWS c\u00f3 c\u00f4ng th\u1ee9c s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 \u201c=ROWS(array)\u201d. Trong \u0111\u00f3, array l\u00e0 \u0111\u1ed1i s\u1ed1 duy nh\u1ea5t v\u00e0 b\u1eaft bu\u1ed9c c\u1ee7a h\u00e0m. N\u00f3 \u0111\u1ea1i di\u1ec7n cho v\u00f9ng d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 h\u00e0ng. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp tr\u1ef1c ti\u1ebfp m\u1ed9t m\u1ea3ng v\u00e0o c\u00f4ng th\u1ee9c ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t v\u00f9ng tr\u00ean b\u1ea3ng t\u00ednh b\u1eb1ng c\u00e1ch ch\u1ecdn n\u00f3.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385466 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19.jpg\" alt=\"ham-thong-ke-trong-excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m COLUMN<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u0111\u00f3 l\u00e0 h\u00e0m COLUMN. \u0110\u00e2y l\u00e0 h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ee7a c\u1ed9t so v\u1edbi \u00f4 ho\u1eb7c c\u1ed9t \u0111\u1ea7u ti\u00ean thu\u1ed9c d\u00e3y \u00f4 c\u1ea7n \u0111\u01b0\u1ee3c tham chi\u1ebfu. C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COLUMN r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u00f3 l\u00e0 =COLUMN([reference]).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385467 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20.jpg\" alt=\"ham-thong-ke-trong-excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">H\u00e0m COLUMNS<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">H\u00e0m COLUMNS l\u00e0 h\u00e0m th\u1ed1ng k\u00ea \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t c\u00f3 trong m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u ho\u1eb7c m\u1ea3ng \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh. V\u1ec1 b\u1ea3n ch\u1ea5t, h\u00e0m COLUMNS th\u1ef1c hi\u1ec7n \u0111\u1ebfm s\u1ed1 c\u1ed9t hi\u1ec7n di\u1ec7n trong m\u1ed9t ph\u1ea1m vi \u00f4 \u0111\u01b0\u1ee3c cung c\u1ea5p.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Do \u0111\u00f3, h\u00e0m n\u00e0y gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng n\u1eafm b\u1eaft c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng <\/span><span style=\"font-weight: 400;\">t\u00ednh, \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c v\u00f9ng d\u1eef li\u1ec7u l\u1edbn ho\u1eb7c ph\u1ee9c t\u1ea1p.<\/span><span style=\"font-weight: 400;\">C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m COLUMN r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u00f3 l\u00e0 \u201c=COLUMN(array).\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385468 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21.jpg\" alt=\"ham-thong-ke-trong-excel-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><span style=\"font-weight: 400;\">M\u1ed9t s\u1ed1 l\u1ed7i sai th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng h\u00e0m th\u1ed1ng k\u00ea trong Excel\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea Excel, b\u1ea1n s\u1ebd d\u1ec5 m\u1eafc ph\u1ea3i m\u1ed9t s\u1ed1 l\u1ed7i sai khi\u1ebfn c\u00e1c h\u00e0m kh\u00f4ng th\u1ec3 ho\u1ea1t \u0111\u1ed9ng ho\u1eb7c \u0111\u01b0a ra sai k\u1ebft qu\u1ea3. Nh\u1eefng l\u1ed7i n\u00e0y c\u00f3 th\u1ec3 do qu\u00e1 tr\u00ecnh \u0111\u00e1nh m\u00e1y ho\u1eb7c s\u1eed d\u1ee5ng h\u00e0m ch\u01b0a \u0111\u00fang c\u00e1ch. Do \u0111\u00f3, khi s\u1eed d\u1ee5ng h\u00e0m n\u00e0y, b\u1ea1n c\u1ea7n l\u01b0u \u00fd m\u1ed9t s\u1ed1 l\u1ed7i d\u01b0\u1edbi \u0111\u00e2y:\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i sai c\u00e1c d\u1ea5u ph\u1ea9y, d\u1ea5u ch\u1ea5m ph\u1ea9y v\u00e0 d\u1ea5u ch\u1ea5m\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i sai m\u00e0 b\u1ea1n th\u01b0\u1eddng xuy\u00ean m\u1eafc ph\u1ea3i khi g\u00f5 c\u00f4ng th\u1ee9c h\u00e0m trong Excel. Ngo\u00e0i ra, b\u1ea1n c\u0169ng s\u1ebd m\u1eafc ph\u1ea3i l\u1ed7i s\u1eed d\u1ee5ng sai d\u1ea5u c\u00e1ch gi\u1eefa c\u00e1c y\u1ebfu t\u1ed1 trong h\u00e0m.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Do \u0111\u00f3, khi s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea b\u1ea1n c\u1ea7n ph\u1ea3i th\u1eadt c\u1ea9n th\u1eadn khi g\u00f5 m\u00e1y. \u0110\u1ed3ng th\u1eddi, khi nh\u1eadp h\u00e0m trong Excel, b\u1ea1n c\u1ea7n ki\u1ec3m tra xem \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u00fang c\u00e1c d\u1ea5u hay ch\u01b0a.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #VALUE!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i #VALUE! th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n khi c\u00f3 sai s\u00f3t trong qu\u00e1 tr\u00ecnh t\u00ednh to\u00e1n, ch\u1ee7 y\u1ebfu do nh\u1eadp c\u00f4ng th\u1ee9c ho\u1eb7c tham chi\u1ebfu \u00f4 kh\u00f4ng ch\u00ednh x\u00e1c. \u0110\u1ec3 tr\u00e1nh l\u1ed7i n\u00e0y, h\u00e3y ki\u1ec3m tra k\u1ef9 c\u00e1c h\u00e0m v\u00e0 \u00f4 d\u1eef li\u1ec7u khi nh\u1eadp h\u00e0m th\u1ed1ng k\u00ea trong Excel.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i kh\u00f4ng vi\u1ebft \u0111\u01b0\u1ee3c s\u1ed1 0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0110\u00e2y l\u00e0 m\u1ed9t trong nh\u1eefng l\u1ed7i b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd m\u1eafc ph\u1ea3i khi nh\u1eadp nh\u1eefng d\u00e3y s\u1ed1 c\u00f3 s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u nh\u01b0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i ho\u1eb7c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng. L\u1ed7i n\u00e0y b\u1ea1n th\u01b0\u1eddng m\u1eafc ph\u1ea3i do kh\u00f4ng c\u00f3 c\u00e1c k\u00fd t\u1ef1 ph\u1ee5 ho\u1eb7c ch\u01b0a chuy\u1ec3n \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng. Do \u0111\u00f3, \u0111\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y b\u1ea1n c\u1ea7n ph\u1ea3i th\u00eam d\u1ea5u \u2018 tr\u01b0\u1edbc con s\u1ed1 0 ho\u1eb7c \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng sang ch\u1eef.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-385469 webpexpress-processed\" src=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22.jpg\" alt=\"ham-thong-ke-trong-excel-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #N\/A!\u00a0<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng l\u1ed7i kh\u00e1c m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p ph\u1ea3i khi s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea \u0111\u00f3 l\u00e0 l\u1ed7i #N\/A!. \u0110\u00e2y l\u00e0 m\u1ed9t l\u1ed7i th\u01b0\u1eddng x\u1ea3y ra v\u1edbi nguy\u00ean nh\u00e2n kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 ho\u1eb7c tr\u1ea3 v\u1ec1 do c\u00f4ng th\u1ee9c sai. Do \u0111\u00f3, b\u1ea1n c\u1ea7n ph\u1ea3i ki\u1ec3m tra l\u1ea1i to\u00e0n b\u1ed9 c\u00e1c h\u00e0m \u0111\u00e3 nh\u1eadp v\u00e0 gi\u00e1 tr\u1ecb v\u00f9ng d\u1eef li\u1ec7u \u0111\u1ec3 h\u00e0m t\u1ef1 \u0111\u1ed9ng t\u00ednh to\u00e1n \u0111\u00fang.\u00a0<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">L\u1ed7i #DIV\/0!<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">L\u1ed7i sai n\u00e0y th\u01b0\u1eddng hi\u1ec3n th\u1ecb khi b\u1ea1n kh\u00f4ng r\u00e0 so\u00e1t t\u00ednh logic c\u1ee7a c\u00f4ng th\u1ee9c h\u00e0m th\u1ed1ng k\u00ea \u0111\u00e3 nh\u1eadp. \u0110\u00e2y l\u00e0 l\u1ed7i ph\u00e9p t\u00ednh b\u1edfi v\u00ec chia cho ch\u1eef s\u1ed1 0 ho\u1eb7c c\u00f4ng th\u1ee9c h\u00e0m sai do th\u1ef1c hi\u1ec7n ph\u00e9p chia v\u1edbi con s\u1ed1 0. \u0110\u1ec3 kh\u1eafc ph\u1ee5c l\u1ed7i n\u00e0y, b\u1ea1n c\u1ea7n xem l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 ch\u1ec9nh s\u1eeda h\u1ee3p l\u00fd.\u00a0<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">T\u1ed5ng k\u1ebft\u00a0<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Th\u00f4ng qua b\u00e0i vi\u1ebft tr\u00ean, b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 hi\u1ec7u qu\u1ea3. Vi\u1ec7c n\u1eafm r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m tr\u00ean s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian t\u00ednh to\u00e1n v\u00e0 th\u1ed1ng k\u00ea c\u00e1c gi\u00e1 tr\u1ecb, d\u1eef li\u1ec7u ch\u00ednh x\u00e1c h\u01a1n.\u00a0<\/span><\/p>\n<p>Xem th\u00eam:<\/p>\n<ul>\n<li class=\"elementor-heading-title elementor-size-default\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-counta\/\">C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m COUNTA trong Excel c\u00f3 v\u00ed d\u1ee5 chi ti\u1ebft<\/a><\/strong><\/li>\n<li class=\"elementor-heading-title elementor-size-default\"><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-viet-hoa-chu-cai-dau\/\">H\u00e0m vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong Excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong Excel, h\u00e0m th\u1ed1ng k\u00ea l\u00e0 m\u1ed9t h\u00e0m r\u1ea5t ph\u1ed5 bi\u1ebfn v\u1edbi c\u00e1ch d\u00f9ng kh\u00f4ng qu\u00e1 ph\u1ee9c t\u1ea1p nh\u01b0ng s\u1ebd g\u00e2y s\u1ef1 nh\u1ea7m l\u1eabn cho nh\u1eefng ng\u01b0\u1eddi m\u1edbi l\u00e0m quen v\u1edbi ph\u1ea7n m\u1ec1m. Do \u0111\u00f3, b\u1ea1n c\u1ea7n n\u1eafm \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a c\u00e1c h\u00e0m th\u1ed1ng k\u00ea v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1ec5 d\u00e0ng t\u00ednh to\u00e1n v\u00e0 [&hellip;]<\/p>\n","protected":false},"author":91,"featured_media":385451,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-385446","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"C\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda\" \/>\n<meta property=\"og:description\" content=\"C\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-15T03:57:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tr\u1ea7n Tuy\u1ebft Nhung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tr\u1ea7n Tuy\u1ebft Nhung\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\"},\"author\":{\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e8c3c63cc973434095bcbcd9659156a7\"},\"headline\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda\",\"datePublished\":\"2024-09-15T03:57:04+00:00\",\"dateModified\":\"2024-09-15T03:57:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\"},\"wordCount\":4586,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\",\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg\",\"datePublished\":\"2024-09-15T03:57:04+00:00\",\"dateModified\":\"2024-09-15T03:57:04+00:00\",\"description\":\"C\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"ham-thong-ke-trong-excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e8c3c63cc973434095bcbcd9659156a7\",\"name\":\"Tr\u1ea7n Tuy\u1ebft Nhung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0ae2ffd14306cd610c0e6991e7796d2a.jpg?ver=1774865221\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0ae2ffd14306cd610c0e6991e7796d2a.jpg?ver=1774865221\",\"caption\":\"Tr\u1ea7n Tuy\u1ebft Nhung\"},\"description\":\"M\u00ecnh l\u00e0 Tr\u1ea7n Tuy\u1ebft Nhung, ng\u01b0\u1eddi chia s\u1ebb ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt s\u1ed1 v\u00e0 nh\u1eefng tips h\u1eefu \u00edch gi\u00fap t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u00e0ng ng\u00e0y tr\u00ean thi\u1ebft b\u1ecb s\u1ed1. M\u00ecnh lu\u00f4n c\u1eadp nh\u1eadt xu h\u01b0\u1edbng m\u1edbi, mang \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng \u0111\u1ec3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/tuyet-nhung\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t","description":"C\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda","og_description":"C\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2024-09-15T03:57:04+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg","type":"image\/jpeg"}],"author":"Tr\u1ea7n Tuy\u1ebft Nhung","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Tr\u1ea7n Tuy\u1ebft Nhung","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"21 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/"},"author":{"name":"Tr\u1ea7n Tuy\u1ebft Nhung","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e8c3c63cc973434095bcbcd9659156a7"},"headline":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda","datePublished":"2024-09-15T03:57:04+00:00","dateModified":"2024-09-15T03:57:04+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/"},"wordCount":4586,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/","name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg","datePublished":"2024-09-15T03:57:04+00:00","dateModified":"2024-09-15T03:57:04+00:00","description":"C\u00e1c c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft nh\u1ea5t gi\u00fap b\u1ea1n t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2024\/09\/ham-thong-ke-trong-excel.jpg","width":1200,"height":628,"caption":"ham-thong-ke-trong-excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-thong-ke-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m th\u1ed1ng k\u00ea trong Excel \u0111\u01a1n gi\u1ea3n, \u0111\u1ea7y \u0111\u1ee7 nh\u1ea5t, c\u00f3 v\u00ed d\u1ee5 minh h\u1ecda"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/e8c3c63cc973434095bcbcd9659156a7","name":"Tr\u1ea7n Tuy\u1ebft Nhung","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0ae2ffd14306cd610c0e6991e7796d2a.jpg?ver=1774865221","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/litespeed\/avatar\/0ae2ffd14306cd610c0e6991e7796d2a.jpg?ver=1774865221","caption":"Tr\u1ea7n Tuy\u1ebft Nhung"},"description":"M\u00ecnh l\u00e0 Tr\u1ea7n Tuy\u1ebft Nhung, ng\u01b0\u1eddi chia s\u1ebb ki\u1ebfn th\u1ee9c v\u1ec1 c\u00f4ng ngh\u1ec7, th\u1ee7 thu\u1eadt s\u1ed1 v\u00e0 nh\u1eefng tips h\u1eefu \u00edch gi\u00fap t\u1ed1i \u01b0u tr\u1ea3i nghi\u1ec7m h\u00e0ng ng\u00e0y tr\u00ean thi\u1ebft b\u1ecb s\u1ed1. M\u00ecnh lu\u00f4n c\u1eadp nh\u1eadt xu h\u01b0\u1edbng m\u1edbi, mang \u0111\u1ebfn c\u00e1c h\u01b0\u1edbng d\u1eabn \u0111\u01a1n gi\u1ea3n, d\u1ec5 \u00e1p d\u1ee5ng \u0111\u1ec3 ai c\u0169ng c\u00f3 th\u1ec3 t\u1eadn d\u1ee5ng c\u00f4ng ngh\u1ec7 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/tuyet-nhung\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/385446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=385446"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/385446\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/385451"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=385446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=385446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=385446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}