{"id":6508,"date":"2024-12-21T15:28:02","date_gmt":"2024-12-21T15:28:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dem-co-dieu-kien-mot-gia-tri-cu-the-trong-nhieu-trang-tinh\/"},"modified":"2024-12-21T15:28:02","modified_gmt":"2024-12-21T15:28:02","slug":"cach-dem-co-dieu-kien-mot-gia-tri-cu-the-trong-nhieu-trang-tinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-dem-co-dieu-kien-mot-gia-tri-cu-the-trong-nhieu-trang-tinh\/","title":{"rendered":"C\u00e1ch \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong nhi\u1ec1u trang t\u00ednh"},"content":{"rendered":"
\n

Gi\u1ea3 s\u1eed, t\u00f4i c\u00f3 nhi\u1ec1u trang t\u00ednh ch\u1ee9a nh\u1eefng d\u1eef li\u1ec7u sau, t\u00f4i mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb \u201cExcel\u201d t\u1eeb c\u00e1c trang n\u00e0y.<\/p>\n

<\/p>\n

\u0110\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n m\u1ed9t gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 trong nhi\u1ec1u trang t\u00ednh b\u1eb1ng c\u00f4ng th\u1ee9c<\/strong><\/p>\n

1. Li\u1ec7t k\u00ea t\u1ea5t c\u1ea3 t\u00ean trang t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u1ebfm v\u00e0o m\u1ed9t c\u1ed9t nh\u01b0 h\u00ecnh sau:<\/p>\n

\"doc-count-across-multiple-sheets-5\"<\/p>\n

2. Trong \u00f4 tr\u1ed1ng, nh\u1eadp c\u00f4ng th\u1ee9c:<\/p>\n

=SUMPRODUCT(COUNTIF(INDIRECT(\u201c\u2018\u201d&C2:C4&\u201d\u2018!A2:A6\u201d),E2))<\/strong><\/em><\/p>\n

Sau \u0111\u00f3 nh\u1ea5n Enter, b\u1ea1n s\u1ebd c\u00f3 s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a \u201cExcel\u201d t\u1eeb c\u00e1c trang t\u00ednh n\u00e0y:<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\"doc-count-across-multiple-sheets-6\"<\/p>\n

Ch\u00fa \u00fd.<\/strong><\/p>\n

1. Trong c\u00f4ng th\u1ee9c tr\u00ean:<\/p>\n

A2:A6\u00a0<\/strong>l\u00e0 v\u00f9ng d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n c\u1ee7a gi\u00e1 tr\u1ecb trong c\u00e1c trang t\u00ednh;<\/p>\n

C2:C4\u00a0<\/strong>l\u00e0 danh s\u00e1ch t\u00ean trang t\u00ednh ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng;<\/p>\n

E2\u00a0<\/strong>l\u00e0 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n \u0111\u1ebfm.<\/p>\n

2. N\u1ebfu c\u00f3 nhi\u1ec1u trang t\u00ednh c\u1ea7n \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc b\u00e0i\u00a0C\u00e1ch li\u1ec7t k\u00ea t\u00ean trang t\u00ednh trong Excel\u00a0<\/strong>\u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c n\u00e0y.<\/p>\n

3. Trong Excel, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0COUNTIF\u00a0<\/strong><\/em>\u0111\u1ec3 th\u00eam t\u1eebng trang t\u00ednh m\u1ed9t nh\u01b0 sau:<\/p>\n

=COUNTIF(Sheet1!A2:A6,D2)+COUNTIF(Sheet10!A2:A6,D2)+COUNTIF(Sheet15!A2:A6,D2)<\/strong><\/em><\/p>\n

Trong \u0111\u00f3, Sheet1, Sheet5 v\u00e0 Sheet15 l\u00e0 nh\u1eefng trang b\u1ea1n mu\u1ed1n \u0111\u1ebfm, D2 ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ea1n c\u1ea7n \u0111\u1ebfm s\u1ed1 l\u1ea7n xu\u1ea5t hi\u1ec7n). Nh\u1ea5n Enter \u0111\u1ec3 hi\u1ec7n k\u1ebft qu\u1ea3.<\/p>\n

\"doc-count-across-multiple-sheets-7\"<\/p>\n

\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6509,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6508","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\/6508","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=6508"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6508\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6509"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}