{"id":7632,"date":"2024-12-21T18:09:33","date_gmt":"2024-12-21T18:09:33","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ung-dung-ham-sumproduct-dem-o-chua-so-le\/"},"modified":"2024-12-21T18:09:33","modified_gmt":"2024-12-21T18:09:33","slug":"ung-dung-ham-sumproduct-dem-o-chua-so-le","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/ung-dung-ham-sumproduct-dem-o-chua-so-le\/","title":{"rendered":"\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, ta s\u1ebd \u1ee9ng d\u1ee5ng 2 h\u00e0m: h\u00e0m MOD v\u00e0 h\u00e0m SUMPRODUCT trong Excel<\/a> <\/strong>\u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb. C\u00f9ng H\u1ecdc Excel Online<\/strong><\/a> b\u1eaft \u0111\u1ea7u ngay th\u00f4i\u00a0\u00a0<\/em><\/p>\n

MOD v\u00e0 SUMPRODUCT trong Excel \u0111\u1ebfm \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb<\/h2>\n

Ta \u0111\u1ec1u \u0111\u00e3 bi\u1ebft s\u1ed1 l\u1ebb l\u00e0 nh\u1eefng s\u1ed1 chia 2 d\u01b0 1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ta s\u1ebd k\u1ebft h\u1ee3p 2 h\u00e0m l\u00e0 MOD v\u00e0 SUMPRODUCT \u0111\u1ec3 ti\u1ebfn h\u00e0nh \u0111\u1ebfm nh\u1eefng \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb trong Excel.<\/p>\n

D\u1eef li\u1ec7u m\u1eabu c\u1ee7a ta nh\u01b0 sau:<\/p>\n

\"ung-dung-ham-sumproduct-dem-o-chua-so-le-1\"<\/p>\n

Y\u00eau c\u1ea7u: \u0110\u1ebfm nh\u1eefng \u00f4 ch\u1ee9a s\u1ed1 l\u1ebb.<\/p>\n

C\u00f4ng th\u1ee9c h\u00e0m SUMPRODUCT excel trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u1ee7a ta nh\u01b0 sau:<\/p>\n

=SUMPRODUCT(\u2013(MOD(A1:A15,2)=1))<\/strong><\/em><\/p>\n

C\u00f4ng th\u1ee9c\u00a0(MOD(A1:A15,2)=1) s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb\u00a0d\u1ea1ng m\u1ea3ng {TRUE; FALSE} t\u01b0\u01a1ng \u1ee9ng:\u00a0TRUE\u00a0<\/strong>n\u1ebfu \u00f4 kh\u00f4ng chia h\u1ebft cho 2 v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.\u00a0\u2014<\/strong> bi\u1ebfn TRUE th\u00e0nh 1, FALSE th\u00e0nh 0. Cu\u1ed1i c\u00f9ng ta l\u1ed3ng v\u00e0o\u00a0SUMPRODUCT<\/strong> tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 s\u1ed1 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 l\u1ebb.<\/p>\n

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

\"ung-dung-ham-sumproduct-dem-o-chua-so-le-2\"<\/p>\n

\n

Ngo\u00e0i ra b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft trong Kh\u00f3a h\u1ecdc Excel<\/strong><\/a> c\u1ee7a ch\u00fang t\u00f4i :<\/p>\n

B\u00ed k\u00edp v\u00f5 l\u00e2m 2: SUMPRODUCT th\u1ea7n ch\u01b0\u1edfng<\/strong><\/a><\/p>\n

4 tuy\u1ec7t chi\u00eau tra c\u1ee9u trong Excel<\/strong><\/a><\/p>\n

\u1ee8ng d\u1ee5ng h\u00e0m INT v\u00e0 MOD trong c\u00f4ng vi\u1ec7c<\/strong><\/a><\/p>\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":7633,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-7632","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\/7632","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=7632"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7632\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7633"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7632"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}