{"id":8167,"date":"2024-12-22T04:08:09","date_gmt":"2024-12-22T04:08:09","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-cach-tinh-cong-don-n-dong-hoac-n-cot-trong-excel\/"},"modified":"2024-12-22T04:08:09","modified_gmt":"2024-12-22T04:08:09","slug":"huong-dan-cach-tinh-cong-don-n-dong-hoac-n-cot-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/huong-dan-cach-tinh-cong-don-n-dong-hoac-n-cot-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u00ednh c\u1ed9ng d\u1ed3n n d\u00f2ng ho\u1eb7c n c\u1ed9t trong excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee9 2 hay 3 hay n d\u00f2ng (ho\u1eb7c c\u1ed9t) tr\u00ean b\u1ea3ng t\u00ednh Excel th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc b\u00e0i vi\u1ebft sau \u0111\u00e2y.<\/p>\n<h2>C\u1ed9ng d\u1ed3n c\u1ee9 3 d\u00f2ng 1 l\u1ea7n<\/h2>\n<p>Gi\u1ea3 s\u1eed, v\u00f9ng c\u1ea7n t\u00ednh t\u1ed5ng l\u00e0 A1:A1000. Ch\u00fang ta s\u1ebd k\u1ebft h\u1ee3p <strong>h\u00e0m ROW<\/strong> v\u00e0 <strong>h\u00e0m MOD<\/strong> trong Excel \u0111\u1ec3 c\u00f3 th\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y.<\/p>\n<p><a href=\"https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2017\/02\/Screen-Shot-2017-02-08-at-13.56.28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2720\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screen-shot-2017-02-08-at-13-56-28-1024x342-1.png\" alt=\"tinh tong ham mod va row\" width=\"1024\" height=\"342\" title=\"screen-shot-2017-02-08-at-13-56-28-1024x342-1\"><\/a><\/p>\n<p>Trong h\u00ecnh v\u1ebd tr\u00ean:<\/p>\n<ul style=\"list-style-type: square\">\n<li>C\u1ed9t A: ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb c\u1ea7n t\u00ednh t\u1ed5ng<\/li>\n<li>C\u1ed9t B: k\u1ebft qu\u1ea3 tr\u1ea3 l\u1ea1i c\u1ee7a h\u00e0m =ROW(A2)<\/li>\n<li>C\u1ed9t C: k\u1ebft qu\u1ea3 tr\u1ea3 l\u1ea1i c\u1ee7a h\u00e0m =MOD(ROW(A2),3)<\/li>\n<li>C\u1ed9t D,E,F: tu\u1ef3 thu\u1ed9c v\u00e0o vi\u1ec7c b\u1ea1n mu\u1ed1n b\u1eaft \u0111\u1ea7u t\u00ednh t\u1ed5ng t\u1eeb gi\u00e1 tr\u1ecb n\u00e0o m\u00e0 b\u1ea1n s\u1ebd ch\u1ecdn c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng.<\/li>\n<\/ul>\n<p>Cu\u1ed1i c\u00f9ng, \u0111\u1ec3 t\u00ednh t\u1ed5ng, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng sau \u0111\u00e2y:<\/p>\n<p><strong>=SUM(A2:A20*(\u2013MOD(ROW(A2:A20),3)=1))<\/strong><\/p>\n<p>r\u1ed3i b\u1ea5m CTRL + SHIFT + ENTER<\/p>\n<p>Thay s\u1ed1 3 b\u1eb1ng s\u1ed1 d\u00f2ng m\u00e0 c\u1ee9 sau s\u1ed1 d\u00f2ng \u0111\u00f3 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-738.gif\" title=\"ex101_92019-nho-738\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p l\u00e0m v\u1edbi c\u1ed9t, b\u1ea1n ch\u1ec9 vi\u1ec7c thay \u0111\u1ed5i h\u00e0m ROW th\u00e0nh h\u00e0m COLUMN. V\u00ed d\u1ee5<\/p>\n<p><strong>=SUM(A1:ZZ1*(\u2013MOD(COLUMN(A1:ZZ1),3)=1))<\/strong><\/p>\n<p>C\u00f4ng th\u1ee9c tr\u00ean s\u1ebd t\u00ednh t\u1ed5ng c\u1ee9 3 c\u1ed9t m\u1ed9t.<\/p>\n<p>Trong Excel c\u00f3 r\u1ea5t nhi\u1ec1u h\u00e0m v\u00e0 c\u00f4ng c\u1ee5 b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng. M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n v\u00e0 n\u00e2ng cao nh\u01b0 IF, VLOOKUP, HLOOKUP,\u00a0SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH, \u2026 v\u00e0 c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026 b\u1ea1n n\u00ean t\u00ecm hi\u1ec3u v\u00e0 s\u1eed d\u1ee5ng \u0111\u1ec3 ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh.<\/p>\n<p style=\"text-align: left\">Hi\u1ec7n t\u1ea1i, Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-738.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8167","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=8167"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8168"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}