{"id":11076,"date":"2025-01-15T01:20:25","date_gmt":"2025-01-15T01:20:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-anchored-countif-dem-so-lan-xuat-hien-trong-excel\/"},"modified":"2025-01-15T01:20:25","modified_gmt":"2025-01-15T01:20:25","slug":"huong-dan-su-dung-ham-anchored-countif-dem-so-lan-xuat-hien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-su-dung-ham-anchored-countif-dem-so-lan-xuat-hien-trong-excel\/","title":{"rendered":"H\u01af\u1edaNG D\u1eaaN S\u1eec D\u1ee4NG H\u00c0M ANCHORED COUNTIF (\u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n) TRONG EXCEL"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-anchored-countif-dem-lan-xuat-hien-trong-excel.html\">H\u00e0m Anchored COUNTIF <\/a>l\u00e0 m\u1ed9t trong nh\u1eefng th\u1ee7 thu\u1eadt \u0111\u01b0\u1ee3c y\u00eau th\u00edch trong Excel. Vi\u1ec7c \u00e1p d\u1ee5ng k\u1ef9 thu\u1eadt n\u00e0y mang l\u1ea1i r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch \u0111\u1eb7c bi\u1ec7t, \u0111\u00e2y l\u00e0 m\u1ed9t h\u00e0m x\u1ee9ng \u0111\u00e1ng \u0111\u1ec3 h\u1ecdc. N\u00f3 kh\u00f4ng gi\u1ed1ng nh\u01b0 c\u00e1c h\u00e0m lookup th\u00f4ng th\u01b0\u1eddng, h\u00e0m Anchored COUNTIF l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 tuy\u1ec7t v\u1eddi c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p v\u1edbi <a href=\"http:\/\/blog.ezworkapp.com\/ham-vlookup-trong-excel-huong-dan-su-dung-chi-tiet-va-co-vi-du-cu-the.html\">h\u00e0m lookup<\/a> \u0111\u1ec3 n\u00e2ng cao hi\u1ec7u su\u1ea5t c\u1ee7a b\u1ea1n khi l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u.<\/p>\n<p><strong>H\u00e0m Anchored COUNTIF l\u00e0 g\u00ec?<\/strong><\/p>\n<p>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>Anchored COUNTIF<\/strong><\/p>\n<p>H\u00e0m Anchored COUNTIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111i\u1ec3n h\u00ecnh trong c\u00e1c d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn giao d\u1ecbch.\u0110\u1ec3 \u00e1p d\u1ee5ng n\u00f3 m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t tr\u01b0\u1eddng m\u1edbi v\u00e0 copy c\u00f4ng th\u1ee9c v\u00e0o b\u1ea3ng. Khi h\u00e0m Anchored COUTIF ho\u1ea1t \u0111\u1ed9ng, n\u00f3 s\u1ebd cho ra k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n theo th\u1ee9 t\u1ef1 c\u1ee7a m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0o \u0111\u00f3 trong ph\u1ea1m vi tr\u01b0\u1eddng m\u00e0 b\u1ea1n tham chi\u1ebfu.<\/p>\n<p>H\u00e3y xem v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10841\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-1-220x300-1.png\" width=\"550\" height=\"749\" title=\"17-10-1-220x300-1\"><\/p>\n<p>Trong v\u00ed d\u1ee5 tr\u00ean,ch\u00fang ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 ho\u1ea1t \u0111\u1ed9ng b\u00e1n h\u00e0ng g\u1ed3m hai c\u1ed9t l\u00e0 S\u1ea3n ph\u1ea9m \u0111\u00e3 b\u00e1n (Product) v\u00e0 Gi\u00e1 b\u00e1n c\u1ee7a s\u1ea3n ph\u1ea9m (Sales Price). B\u1edfi v\u00ec b\u1ea3ng n\u00e0y \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo s\u1ea3n ph\u1ea9m, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng nh\u1eadn th\u1ea5y h\u00e0m Anchored COUNTIF \u0111ang ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o. M\u1ed7i s\u1ea3n ph\u1ea9m s\u1ebd c\u00f3 s\u1ed1 th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, v\u00e0 khi m\u1ed9t s\u1ea3n ph\u1ea9m m\u1edbi xu\u1ea5t hi\u1ec7n th\u00ec h\u00e0m s\u1ebd t\u00ednh to\u00e1n l\u1ea1i t\u1eeb \u0111\u1ea7u.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 kh\u00e1c, l\u1ea7n n\u00e0y c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo gi\u00e1 (sales price). Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y s\u1ebd kh\u00f3 \u0111\u1ec3 nh\u00ecn ra, nh\u01b0ng h\u00e0m Anchored COUNTIF v\u1eabn \u0111ang cho ra c\u00f9ng m\u1ed9t k\u1ebft qu\u1ea3- s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n theo th\u1ee9 t\u1ef1 c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m.<\/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-256.gif\" title=\"ex101_92019-nho-256\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10842\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-2-220x300-1.png\" width=\"550\" height=\"749\" title=\"17-10-2-220x300-1\"><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tag\/hoc-excel-2003\">Excel 2003<\/a><\/p>\n<\/blockquote>\n<p>V\u00ed d\u1ee5 tr\u00ean ch\u1ec9 ra m\u1ed9t \u0111\u1eb7c \u0111i\u1ec3m ch\u00ednh c\u1ee7a h\u00e0m l\u00e0 n\u00f3 s\u1ebd v\u1eabn ho\u1ea1t \u0111\u1ed9ng cho d\u00f9 b\u1ea1n c\u00f3 s\u1eafp x\u1ebfp l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb trong b\u1ea3ng.<\/p>\n<p><strong>L\u01b0u \u00fd<\/strong> r\u1eb1ng s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng c\u00f3 th\u1ec3 b\u1ecb thay \u0111\u1ed5i sau khi s\u1eafp x\u1ebfp l\u1ea1i. V\u00ed d\u1ee5, s\u1ea3n ph\u1ea9m Longhorn \u0111\u1ee9ng th\u1ee9 3 l\u1ea1i \u0111\u1ee9ng th\u1ee9 4 sau khi re-sort.<\/p>\n<p>Khi n\u00e0o th\u00ec n\u00ean s\u1eed d\u1ee5ng h\u00e0m Anchored COUNTIF?<\/p>\n<p>H\u00e3y coi h\u00e0m Anchored COUNTIF l\u00e0 \u00a0b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean \u0111\u1ec3 hi\u1ec3u v\u1ec1 c\u00e1c gi\u00e1 tr\u1ecb. Sau khi l\u1eadp c\u00f4ng th\u1ee9c, s\u1ebd c\u00f3 b\u1ed1n c\u00e1ch c\u01a1 b\u1ea3n gi\u00fap b\u1ea1n t\u1ed1i \u01b0u h\u00f3a \u0111\u1ea7u ra c\u1ee7a h\u00e0m Anchored COUNTIF<\/p>\n<ul>\n<li>X\u00e1c \u0111\u1ecbnh l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1edbn nh\u1ea5t c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea5t k\u1ef3<\/li>\n<li>X\u00e1c \u0111\u1ecbnh l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea5t k\u1ef3<\/li>\n<li>X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t c\u1ee7a m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng<\/li>\n<li>\u0110\u01b0a ra key tra c\u1ee9u gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean, l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng.<\/li>\n<\/ul>\n<p>B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c h\u1ecdc c\u00e1ch t\u1ed1i \u01b0u c\u00e1c c\u00e1ch tr\u00ean m\u1ed9t c\u00e1ch chi ti\u1ebft, b\u00e2y gi\u1edd h\u00e3y c\u00f9ng xem c\u00e1ch l\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 th\u1ebf n\u00e0o<\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u1eadp c\u00f4ng th\u1ee9c Anchored COUNTIF?<\/strong><\/p>\n<p>L\u1eadp c\u00f4ng th\u1ee9c h\u00e0m Anchored COUNTIF l\u00e0 vi\u1ec7c kh\u00e1 \u0111\u01a1n gi\u1ea3n. \u0110\u1ec3 b\u1eaft \u0111\u1ea7u , b\u1ea1n c\u1ea7n bi\u1ebft tr\u01b0\u1eddng (ph\u1ea1m vi) m\u00ecnh mu\u1ed1n \u00e1p d\u1ee5ng n\u00f3.<\/p>\n<p>S\u1eed d\u1ee5ng d\u1eef li\u1ec7u trong b\u1ea3ng data ph\u00eda tr\u00ean. H\u00e0m n\u00e0y s\u1ebd gi\u00fap \u00edch nh\u1ea5t trong tr\u01b0\u1eddng h\u1ee3p n\u00f3 \u00a0l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u giao d\u1ecbch ( n\u01a1i c\u00e1c d\u1eef li\u1ec7u c\u00f3 li\u00ean quan c\u00f3 th\u1ec3 s\u1ebd \u0111\u01b0\u1ee3c l\u1eb7p l\u1ea1i) thay v\u00ec d\u1eef i\u1ec7u t\u00f3m t\u1eaft (n\u01a1i d\u1eef li\u1ec7u s\u1ebd \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p t\u00f3m t\u1eaft v\u00e0 ch\u1ec9 m\u1ed9t v\u00e0i \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u1eb7c bi\u1ec7t m\u1edbi \u0111\u01b0\u1ee3c xu\u1ea5t hi\u1ec7n)<\/p>\n<p>B\u1ea3ng ch\u00fang ta \u0111ang s\u1eed d\u1ee5ng ch\u1ec9 ra d\u1eef li\u1ec7u b\u00e1n h\u00e0ng c\u1ee7a r\u1ea5t nhi\u1ec1u s\u1ea3n ph\u1ea9m.\u00a0 M\u1ed7i h\u00e0ng l\u00e0 m\u1ed9t giao d\u1ecbch, v\u00e0 v\u1edbi m\u1ed7i h\u00e0ng ch\u00fang ta c\u00f3 gi\u00e1 b\u00e1n (Sales Price) v\u00e0 lo\u1ea1i s\u1ea3n ph\u1ea9m (Product) \u0111\u00e3 b\u00e1n.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta s\u1ebd \u00e1p d\u1ee5ng h\u00e0m Anchored COUNTIF v\u00e0o tr\u01b0\u1eddng \u201cProduct\u201d b\u1edfi n\u00f3 l\u00e0 tr\u01b0\u1eddng ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb l\u1eb7p l\u1ea1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10843\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-3-260x300-1.png\" width=\"550\" height=\"635\" title=\"17-10-3-260x300-1\"><\/p>\n<p><strong>C\u00fa ph\u00e1p h\u00e0m COUNTIF<br \/>\n<\/strong>Nh\u00ecn chung, h\u00e0m Anchored COUNTIF th\u1ef1c s\u1ef1 l\u00e0 m\u1ed9t <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-countifs-va-countif-voi-nhieu-dieu-kien.html\">h\u00e0m COUNTIF<\/a> \u0111\u01a1n, kh\u00f4ng ph\u1ea3i l\u00e0 h\u00e0m k\u1ebft h\u1ee3p. N\u00f3 c\u00f3 c\u00fa ph\u00e1p nh\u01b0 sau:<\/p>\n<p>Range- ph\u1ea1m vi m\u00e0 h\u00e0m s\u1ebd t\u00ecm ki\u1ebfm<\/p>\n<p>Criteria- gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 m\u00e0 h\u00e0m \u0111ang t\u00ecm ki\u1ebfm (gi\u00e1 tr\u1ecb ti\u00eau chu\u1ea9n)<\/p>\n<p>Ch\u00fang ta s\u1ebd \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c h\u00e0m COUNTIF nh\u01b0 m\u1ed9t n\u1ec1n t\u1ea3ng c\u1ee7a qu\u00e1 tr\u00ecnh n\u00e0y.<\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: B\u1eaft \u0111\u1ea7u vi\u1ebft c\u00f4ng th\u1ee9c<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10844\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-4-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-4-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> L\u1ef1a ch\u1ecdn tr\u01b0\u1eddng b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10845\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-5-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-5-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> G\u00f5 d\u1ea5u hai ch\u1ea5m \u201c:\u201d \u0111\u1ec3 t\u1ea1o m\u1ed9t d\u00e3y<\/p>\n<p>\u00a0<\/p>\n<p>Ch\u00fa \u00fd r\u1eb1ng khi b\u1ea1n g\u00f5 d\u1ea5u hai ch\u1ea5m, th\u00ec m\u1ed9t d\u00e3y gi\u1ed1ng h\u1ec7t s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1eb1ng sau d\u1ea5u hai ch\u1ea5m. \u0110i\u1ec1u b\u1ea1n v\u1eeba l\u00e0m l\u00e0 t\u1ea1o m\u1ed9t d\u00e3y tham chi\u1ebfu trong Excel (b\u1eaft \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac l\u00e0 c\u00e1c \u00f4 b\u1ea1n \u0111\u00e3 ch\u1ecdn). V\u1edbi \u00f4 \u0111\u1ea7u ti\u00ean, \u0111i\u1ec1u n\u00e0y c\u00f3 v\u1ebb kh\u00f4ng quan tr\u1ecdng, nh\u01b0ng n\u00f3 s\u1ebd c\u00f3 ngh\u0129a h\u01a1n khi b\u1ea1n k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng \u0111\u1ec3 \u00e1p d\u1ee5ng v\u1edbi c\u00e1c \u00f4 kh\u00e1c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10846\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-6-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-6-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: Th\u00eam d\u1ea5u ph\u1ea9y \u0111\u1ec3 \u0111\u00f3ng Range<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10847\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-7-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-7-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn \u00f4 ti\u00eau chu\u1ea9n l\u00e0 \u00f4 gi\u1ed1ng v\u1edbi \u00f4 g\u1ed1c m\u00e0 b\u1ea1n \u0111\u00e3 tham chi\u1ebfu<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10848\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-8-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-8-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> \u0110\u00f3ng c\u00f4ng th\u1ee9c b\u1eb1ng d\u1ea5u ngo\u1eb7c \u0111\u01a1n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10849\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-9-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-9-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 7:<\/strong> <strong>QUAN TR\u1eccNG:<\/strong> Quay tr\u1edf l\u1ea1i c\u00f4ng th\u1ee9c v\u00e0 c\u1ed1 \u0111\u1ecbnh gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean trong d\u00e3y<\/p>\n<p>\u0110\u00e2y l\u00e0 b\u01b0\u1edbc r\u1ea5t quan tr\u1ecdng b\u1edfi h\u00e0m Anchored COUNTIF s\u1ebd kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u0111\u01b0\u1ee3c n\u1ebfu kh\u00f4ng c\u00f3 n\u00f3.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10850\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-10-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-10-220x300-1\"><\/p>\n<p><strong>B\u01b0\u1edbc 8:<\/strong> Copy c\u00f4ng th\u1ee9c xu\u1ed1ng d\u01b0\u1edbi \u0111\u1ec3 ho\u00e0n th\u00e0nh b\u1ea3ng<\/p>\n<p>C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y l\u00e0 nh\u1ea5p \u0111\u00fap chu\u1ed9t\u00a0 v\u00e0o d\u01b0\u1edbi g\u00f3c b\u00ean ph\u1ea3i c\u1ee7a \u00f4 b\u1ea1n mu\u1ed1n copy.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10852\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-11-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-11-220x300-1\"><\/p>\n<blockquote>\n<p>\u0110\u0103ng k\u00fd ngay: Kh\u00f3a\u00a0<a href=\"http:\/\/blog.ezworkapp.com\">h\u1ecdc Excel t\u1ea1i nh\u00e0<\/a><\/p>\n<\/blockquote>\n<p><strong>N\u00f3 ho\u1ea1t \u0111\u1ed9ng nh\u01b0 th\u1ebf n\u00e0o?<\/strong><\/p>\n<p>Ch\u00eca kh\u00f3a \u0111\u1ec3 h\u00e0m Anchored COUNTIF ho\u1ea1t \u0111\u1ed9ng \u0111\u00f3 l\u00e0 d\u00e3y tham chi\u1ebfu c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c g\u1eafn (m\u00f3c n\u1ed1i) v\u1edbi \u00f4 \u0111\u1ea7u ti\u00ean. L\u01b0u \u00fd r\u1eb1ng khi b\u1ea1n k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng, c\u00f4ng th\u1ee9c COUNITF s\u1ebd m\u1edf r\u1ed9ng \u0111\u1ec3 bao h\u00e0m t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm .<\/p>\n<p>\u0110i\u1ec1u b\u1ea1n \u0111ang b\u1ea3o Excel l\u00e0m \u0111\u00f3 l\u00e0 ch\u1ec9 ra gi\u00e1 tr\u1ecb n\u00e0y \u0111\u00e3 xu\u1ea5t hi\u1ec7n bao nhi\u00eau l\u1ea7n. \u0110\u00e2y ch\u00ednh l\u00e0 logic \u0111\u1ec3 t\u1ea1o ra s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<p>V\u00ed d\u1ee5, h\u00e3y xem l\u1ea7n xu\u1ea5t hi\u1ec7n th\u1ee9 t\u01b0 c\u1ee7a <strong>Nitro<\/strong>. Ta \u0111ang h\u1ecfi Excel l\u00e0 <strong>Nitro<\/strong> \u0111\u00e3 xu\u1ea5t hi\u1ec7n bao nhi\u00eau l\u1ea7n. C\u00f4ng th\u1ee9c s\u1ebd t\u1ef1 \u0111\u1ebfm m\u1ed7i s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n tr\u01b0\u1edbc \u0111\u00f3 c\u1ee7a <strong>Nitro<\/strong>. V\u00ec v\u1eady, k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10853\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-12-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-12-220x300-1\"><\/p>\n<p>N\u1ebfu b\u1ea1n k\u00e9o xu\u1ed1ng d\u00f2ng ti\u1ebfp theo th\u00ec ti\u00eau ch\u00ed s\u1ebd \u0111\u1ed5i th\u00e0nh <strong>Xenon<\/strong>. V\u00ec ch\u01b0a c\u00f3 s\u1ef1 xu\u1ea5t hi\u1ec7n n\u00e0o tr\u01b0\u1edbc c\u1ee7a <strong>Xenon<\/strong>, n\u00ean h\u00e0m s\u1ebd t\u1ef1 \u0111\u1ebfm v\u00e0 \u0111\u1ec3 k\u1ebft qu\u1ea3 l\u00e0 1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10854\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-13-220x300-1.png\" width=\"550\" height=\"752\" title=\"17-10-13-220x300-1\"><\/p>\n<p><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Anchored COUNTIF?<\/strong><\/p>\n<p><strong>X\u00e1c \u0111\u1ecbnh s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1edbn nh\u1ea5t c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea5t k\u1ef3<\/strong><\/p>\n<p>Vi\u1ec7c ch\u1ec9 ra s\u1ed1 l\u01b0\u1ee3ng nhi\u1ec1u nh\u1ea5t c\u1ee7a s\u1ea3n ph\u1ea9m \u0111\u00e3 b\u00e1n th\u1eadt \u0111\u01a1n gi\u1ea3n sau khi ta \u0111\u00e3 \u00e1p d\u1ee5ng h\u00e0m Anchored COUNTIF. Ch\u1ec9 c\u1ea7n \u00e1p d\u1ee5ng h\u00e0m MAX v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m Anchored COUNTIF. H\u00e0m n\u00e0y s\u1ebd cho b\u1ea1n bi\u1ebft s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n l\u1edbn nh\u1ea5t \u0111\u1ea1t \u0111\u01b0\u1ee3c c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m b\u1ea5t k\u00ec. \u00a0Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 s\u1ed1 5<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10855\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-14-300x300-1.png\" width=\"600\" height=\"599\" title=\"17-10-14-300x300-1\"><\/p>\n<p><strong>X\u00e1c \u0111\u1ecbnh l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng b\u1ea5t k\u00ec<\/strong><\/p>\n<p>L\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean ho\u1eb7c giao d\u1ecbch \u0111\u1ea7u ti\u00ean lu\u00f4n lu\u00f4n l\u00e0 s\u1ed1 \u201c1\u201d theo nh\u01b0 gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m Anchored COUNTIF. V\u00ec v\u1eady, \u0111i\u1ec1u b\u1ea1n c\u1ea7n \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh l\u00e0 t\u00ecm ra t\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng l\u00e0 s\u1ed1 1 trong c\u1ed9t n\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10856\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-15-260x300-1.png\" width=\"550\" height=\"635\" title=\"17-10-15-260x300-1\"><\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u1edf \u0111\u00e2u<\/a>?<\/p>\n<\/blockquote>\n<p><strong>X\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng (y\u00eau c\u1ea7u \u0111\u00e3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp h\u1ee3p l\u00fd)<\/strong><\/p>\n<p>Gi\u1ea3 d\u1ee5,ta mu\u1ed1n x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t c\u1ee7a s\u1ea3n ph\u1ea9m.V\u1ec1 c\u01a1 b\u1ea3n, m\u1ed7i s\u1ea3n ph\u1ea9m s\u1ebd \u0111\u01b0\u1ee3c giao d\u1ecbch v\u1edbi gi\u00e1 th\u1ea5p nh\u1ea5t. \u0110i\u1ec1u c\u1ea7n l\u00e0m l\u00e0 s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n c\u1ee7a c\u1ed9t d\u1ef1a v\u00e0o gi\u00e1 tr\u1ecb trong c\u00e2u h\u1ecfi ( trong TH n\u00e0y l\u00e0 c\u1ed9t gi\u00e1). (ch\u1ecdn tr\u01b0\u1eddng b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp, s\u1eed d\u1ee5ng ph\u00edm t\u1eaft ALT \u2192 A \u2192 S \u2192 A).B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y tr\u01b0\u1edbc ho\u1eb7c sau khi vi\u1ebft c\u00f4ng th\u1ee9c h\u00e0m Anchored COUNTIF. B\u1edfi v\u00ec n\u00f3 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n, n\u00ean l\u1ea7n xu\u1ea5t hi\u1ec7n \u0111\u1ea7u ti\u00ean s\u1ebd c\u00f3 gi\u00e1 th\u1ea5p nh\u1ea5t c\u1ee7a s\u1ea3n ph\u1ea9m. V\u00ec v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng logic t\u01b0\u01a1ng t\u1ef1 nh\u01b0 ph\u1ea7n tr\u00ean \u0111\u1ec3 t\u00ecm ra c\u00e1c d\u00f2ng c\u00f3 \u201c1\u201d \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh gi\u00e1 c\u1ea3 th\u1ea5p nh\u1ea5t.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10857\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-16-260x300-1.png\" width=\"550\" height=\"635\" title=\"17-10-16-260x300-1\"><\/p>\n<p><strong>Cung c\u1ea5p key tra c\u1ee9u gi\u00e1 tr\u1ecb \u0111\u1ea7u ti\u00ean, l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t c\u1ee7a m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng.<\/strong><\/p>\n<p>\u1ede v\u00ed d\u1ee5 tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 d\u00f9ng tr\u1ef1c quan \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3. Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Anchored COUNTIF r\u1ed9ng h\u01a1n b\u1eb1ng c\u00e1ch t\u1ea1o ra m\u1ed9t c\u00f4ng th\u1ee9c tham chi\u1ebfu. Vi\u1ec7c b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 t\u1ea1o m\u1ed9t key tra c\u1ee9u.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n bi\u1ebft top 3 s\u1ea3n ph\u1ea9m b\u00e1n ch\u1ea1y trong b\u1ea3ng n\u00e0y. \u0110\u1ea7u ti\u00ean, h\u00e3y s\u1eafp x\u1ebfp c\u1ed9t gi\u00e1 b\u00e1n theo th\u1ee9 t\u1ef1 gi\u1ea3m d\u1ea7n, v\u00ec v\u1eady th\u1ee9 t\u1ef1 xu\u1ea5t hi\u1ec7n c\u1ee7a m\u1ed7i d\u00f2ng s\u1ebd kh\u1edbp v\u1edbi s\u1ef1 s\u1eafp x\u1ebfp c\u1ee7a \u201cGi\u00e1 b\u00e1n\u201d. B\u00e2y gi\u1edd ch\u00fang ta s\u1ebd t\u1ea1o m\u1ed9t key tra c\u1ee9u \u0111\u01a1n gi\u1ea3n, \u0111\u00f3 l\u00e0 n\u1ed1i gi\u00e1 tr\u1ecb c\u1ee7a h\u00e0m v\u1edbi t\u00ean s\u1ea3n ph\u1ea9m.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10858\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-17-280x300-1.png\" width=\"600\" height=\"644\" title=\"17-10-17-280x300-1\"><\/p>\n<p>Sau khi key tra c\u1ee9u \u0111\u01b0\u1ee3c t\u1ea1o, ta s\u1ebd c\u00f3 m\u1ed9t c\u00f4t v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb \u0111\u1eb7c bi\u1ec7t c\u1ee7a m\u1ed7i giao d\u1ecbch b\u00e1n h\u00e0ng, ch\u00fang \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo s\u1ed1 l\u01b0\u1ee3ng b\u00e1n h\u00e0ng. B\u00e2y gi\u1edd \u0111\u1ec3 \u0111\u00e1p \u1ee9ng y\u00eau c\u1ea7u,h\u00e3y l\u1eadp ra m\u1ed9t c\u00e1i b\u1ea3ng \u0111\u01a1n gi\u1ea3n v\u1edbi s\u1ea3n ph\u1ea9m v\u00e0 th\u1ee9 h\u1ea1ng \u0111\u00e3 c\u00f3 v\u00e0 ch\u1ea1y c\u00f4ng th\u1ee9c lookup \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh top 3 giao d\u1ecbch theo gi\u00e1 b\u00e1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-10859\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/17-10-18-300x208-1.png\" width=\"600\" height=\"417\" title=\"17-10-18-300x208-1\"><\/p>\n<p><strong>K\u1ebft lu\u1eadn<\/strong><\/p>\n<p>H\u00e0m n\u00e0y r\u1ea5t c\u00f3 gi\u00e1 tr\u1ecb trong ph\u00e2n t\u00edch d\u1eef li\u1ec7u. \u0110\u1ec3 t\u1eadn d\u1ee5ng h\u1ebft l\u1ee3i \u00edch c\u1ee7a h\u00e0m, h\u00e3y h\u1ecdc v\u1ec1 c\u00e1c h\u00e0m lookup nh\u01b0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-index-va-ham-match-trong-excel-su-thay-tot-hon-ca-ham-vlookup.html\"><strong>INDEX MATCH<\/strong> v\u00e0 <strong>LOOKUP<\/strong> \u00a0trong Excel<\/a><\/p>\n<p>\u0110\u00e2y ch\u1ec9 l\u00e0 m\u1ed9t trong r\u1ea5t nhi\u1ec1u h\u00e0m c\u1ee7a Excel. \u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH \u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table \u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2mWmtzP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\" target=\"_blank\">HocExcel.Online<\/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-256.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11077,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11076","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\/11076","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=11076"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11076\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11077"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11076"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11076"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}