{"id":8727,"date":"2024-12-27T21:04:02","date_gmt":"2024-12-27T21:04:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/27\/cong-thuc-mang-trong-excel\/"},"modified":"2024-12-27T21:04:02","modified_gmt":"2024-12-27T21:04:02","slug":"cong-thuc-mang-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/27\/cong-thuc-mang-trong-excel\/","title":{"rendered":"C\u00f4ng th\u1ee9c m\u1ea3ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng t\u00ednh s\u1eb5n c\u00f3 b\u1eb1ng c\u00e1ch th\u00eam c\u1ed9t ho\u1eb7c s\u1eafp x\u1ebfp \u0111\u1ec3 h\u1ed7 tr\u1ee3 cho vi\u1ec7c t\u00ednh to\u00e1n, v\u1eady n\u00ean <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-cong-thuc-va-nhung-hang-mang-trong-excel-vi-du-va-huong-dan-su-dung.html\"><strong>c\u00f4ng th\u1ee9c m\u1ea3ng Excel<\/strong><\/a>\u00a0hay <strong>h\u00e0m m\u1ea3ng<\/strong> l\u00e0 k\u0129 thu\u1eadt ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng \u1edf \u0111\u00e2y.<\/p>\n<p>Trong qu\u00e1 tr\u00ecnh x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c m\u1ea3ng trong phi\u00ean b\u1ea3n excel c\u1ee7a b\u1ea1n, h\u00e3y nh\u1edb ph\u00edm <strong>F9<\/strong> l\u00e0 ph\u00edm r\u1ea5t quan tr\u1ecdng b\u1edfi v\u00ec v\u1edbi <strong>F9<\/strong> b\u1ea1n c\u00f3 th\u1ec3 bi\u1ebft \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c ngay tr\u00ean thanh c\u00f4ng th\u1ee9c. \u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam v\u1ec1 h\u00e0m m\u1ea3ng hay c\u00f4ng th\u1ee9c m\u1ea3ng, h\u00e3y theo d\u00f5i video sau \u0111\u00e2y:<\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/_nBhoJmIn-w?autoplay=1&amp;loop=1&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<blockquote>\n<div class=\"videowrapper\" style=\"text-align: left\">\u0110\u1eebng b\u1ecf qua:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/cac-ham-co-ban-trong-excel\">c\u00e1c h\u00e0m c\u01a1 b\u1ea3n trong excel<\/a><\/div>\n<\/blockquote>\n<p>C\u00e1c v\u00ed d\u1ee5 \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong video bao g\u1ed3m:<\/p>\n<ol>\n<li>C\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 t\u00ednh t\u1ed5ng theo \u0111i\u1ec1u ki\u1ec7n, \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>T\u00ednh MIN, MAX hi\u1ec7u 2 m\u1ea3ng<\/li>\n<li>T\u00ednh MIN, MAX theo \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>H\u00e0m Index v\u00e0 Match theo m\u1ea3ng<\/li>\n<li>C\u00f4ng th\u1ee9c SUM, SUMPRODUCT k\u1ebft h\u1ee3p h\u00e0m m\u1ea3ng t\u00ednh t\u1ed5ng chi ph\u00ed<\/li>\n<li>K\u1ebft h\u1ee3p SUM v\u1edbi LARGE\/SMALL \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 c\u1ee7a 3 nh\u00e2n vi\u00ean top \u0111\u1ea7u<\/li>\n<li>\u0110\u00e1nh s\u1ed1 b\u1eb1ng c\u00f4ng th\u1ee9c m\u1ea3ng \u0111\u1ec3 1 th\u00e0nh ph\u1ea7n kh\u00f4ng d\u1ec5 d\u00e0ng b\u1ecb xo\u00e1<\/li>\n<\/ol>\n<h3 id=\"download-ti-liu-lin-quan\">Download t\u00e0i li\u1ec7u li\u00ean quan:<\/h3>\n<p>[sociallocker id=457]<\/p>\n<p><a href=\"https:\/\/db.tt\/AjrTEZMU\" target=\"_blank\" rel=\"noopener\"><strong>Download t\u00e0i li\u1ec7u Excel k\u00e8m theo video<\/strong><\/a><\/p>\n<p>[\/sociallocker]<\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf qua: H\u01b0\u1edbng d\u1eabn\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/excel-2010\">c\u00e1ch h\u1ecdc Excel 2010<\/a><\/p>\n<\/blockquote>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>C\u00f3 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta kh\u00f4ng th\u1ec3 thay \u0111\u1ed5i c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng t\u00ednh..<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8727","post","type-post","status-publish","format-standard","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8727"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8727\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}