{"id":9167,"date":"2025-01-01T20:10:52","date_gmt":"2025-01-01T20:10:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-su-dung-ham-rows-tra-ve-so-luong-hang-cua-tham-chieu-trong-excel\/"},"modified":"2025-01-01T20:10:52","modified_gmt":"2025-01-01T20:10:52","slug":"huong-dan-su-dung-ham-rows-tra-ve-so-luong-hang-cua-tham-chieu-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/01\/huong-dan-su-dung-ham-rows-tra-ve-so-luong-hang-cua-tham-chieu-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m ROWS tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u1ee7a tham chi\u1ebfu trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00f9ng v\u1edbi\u00a0<strong>h\u00e0m COLUMNS<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t c\u1ee7a tham chi\u1ebfu, Excel cung c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng m\u1ed9t h\u00e0m \u0111\u1ec3 \u201cb\u1eaft c\u1eb7p\u201d:\u00a0<strong>h\u00e0m ROWS<\/strong> tr\u1ea3 v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng c\u1ee7a tham chi\u1ebfu. C\u1ee5 th\u1ec3 h\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft b\u00ean d\u01b0\u1edbi:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6775a14c09d96\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-rows-tra-ve-so-luong-hang-tham-chieu.html#Ham_ROWS_cong_dung_va_cu_phap\" title=\"H\u00e0m ROWS, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p\">H\u00e0m ROWS, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-rows-tra-ve-so-luong-hang-tham-chieu.html#Cong_dung_cua_ham_ROWS\" title=\"C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m ROWS\">C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m ROWS<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-rows-tra-ve-so-luong-hang-tham-chieu.html#Cong_thuc_ham\" title=\"C\u00f4ng th\u1ee9c h\u00e0m\">C\u00f4ng th\u1ee9c h\u00e0m<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/su-dung-ham-rows-tra-ve-so-luong-hang-tham-chieu.html#Ung_dung_ham_ROWS\" title=\"\u1ee8ng d\u1ee5ng h\u00e0m ROWS\">\u1ee8ng d\u1ee5ng h\u00e0m ROWS<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_ROWS_cong_dung_va_cu_phap\"><\/span>H\u00e0m ROWS, c\u00f4ng d\u1ee5ng v\u00e0 c\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Cong_dung_cua_ham_ROWS\"><\/span>C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m ROWS<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>H\u00e0m\u00a0ROWS\u00a0tr\u1ea3 v\u1ec1\u00a0t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng\u00a0h\u00e0ng\u00a0c\u1ee7a tham chi\u00ea\u0301u nh\u1ea5t \u0111\u1ecbnh.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Cong_thuc_ham\"><\/span>C\u00f4ng th\u1ee9c h\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>C\u00f4ng th\u1ee9c c\u1ee7a h\u00e0m ROWS nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=ROWS(m\u1ea3ng tham chi\u1ebfu)<\/strong><\/p>\n<\/blockquote>\n<p>Trong \u0111\u00f3\u00a0<strong>m\u1ea3ng tham chi\u1ebfu<\/strong>\u00a0l\u00e0 m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t v\u00f9ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25379\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rows-1.png\" width=\"342\" height=\"108\" title=\"ham-rows-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ung_dung_ham_ROWS\"><\/span>\u1ee8ng d\u1ee5ng h\u00e0m ROWS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 h\u00e0m COLUMNS, ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m ROWS k\u1ebft h\u1ee3p v\u1edbi ch\u1ee9c n\u0103ng Table trong Excel \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng \u0111\u1ebfm s\u1ed1 c\u1ed9t nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25380\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rows-2.png\" width=\"547\" height=\"409\" title=\"ham-rows-2\"><\/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\/2025\/01\/ex101_92019-nho-16.gif\" title=\"ex101_92019-nho-16\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm s\u1ed1 d\u00f2ng c\u1ee7a b\u1ea3ng. V\u1edbi kh\u1ea3 n\u0103ng t\u1ef1 m\u1edf r\u1ed9ng v\u00f9ng, k\u1ebft qu\u1ea3 c\u0169ng s\u1ebd thay \u0111\u1ed5i m\u1ed7i khi ta nh\u1eadp th\u00eam v\u00e0o. B\u1eb1ng c\u00e1ch k\u1ebft h\u1ee3p n\u00e0y, ta c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 d\u00f2ng c\u1ee7a b\u1ea3ng, c\u0169ng nh\u01b0 k\u1ebft h\u1ee3p v\u1edbi nh\u1eefng h\u00e0m kh\u00e1c nh\u01b0 OFFSET \u0111\u1ec3 t\u00ecm ki\u1ebfm d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-25381\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ham-rows-3.png\" width=\"546\" height=\"389\" title=\"ham-rows-3\"><\/p>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t c\u00e1ch l\u00e0m r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 c\u00f3 th\u1ec3 \u0111\u1ebfm \u0111\u01b0\u1ee3c s\u1ed1 d\u00f2ng trong m\u1ed9t b\u1ea3ng v\u00e0 \u0111\u1ed3ng th\u1eddi t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i khi b\u1ea3ng m\u1edf r\u1ed9ng, gi\u00fap ta kh\u00f4ng c\u1ea7n ph\u1ea3i t\u00ednh to\u00e1n l\u1ea1i. K\u1ebft h\u1ee3p v\u1edbi m\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n v\u00e0 n\u00e2ng cao kh\u00e1c, ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c c\u00e1c t\u00e1c v\u1ee5 trong t\u00ednh to\u00e1n v\u1edbi Excel.<\/p>\n<p>Ngo\u00e0i ra c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><strong><a href=\"http:\/\/blog.ezworkapp.com\/ham-row-tra-ve-vi-tri-hang-cua-tham-chieu.html\">C\u00e1ch d\u00f9ng h\u00e0m ROW tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed h\u00e0ng c\u1ee7a tham chi\u1ebfu trong Excel<\/a><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-column-tra-ve-vi-tri-cot-tham-chieu.html\"><strong>H\u01b0\u1edbng d\u1eabn h\u00e0m COLUMN tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ed9t c\u1ee7a tham chi\u1ebfu trong Excel<\/strong><\/a><\/p>\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\/2025\/01\/ex101_92019-nho-16.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9167","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=9167"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9168"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}