{"id":10867,"date":"2025-01-15T00:16:18","date_gmt":"2025-01-15T00:16:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-database-trong-excel-dsum-dcount-daverage\/"},"modified":"2025-01-15T00:16:18","modified_gmt":"2025-01-15T00:16:18","slug":"cac-ham-database-trong-excel-dsum-dcount-daverage","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cac-ham-database-trong-excel-dsum-dcount-daverage\/","title":{"rendered":"C\u00e1c h\u00e0m database trong Excel (DSUM, DCOUNT, DAVERAGE)"},"content":{"rendered":"
\n

Trong Excel, b\u00ean c\u1ea1nh nh\u1eefng h\u00e0m c\u01a1 b\u1ea3n nh\u01b0 SUM, COUNT, AVERAGE, c\u00f2n t\u1ed3n t\u1ea1i c\u00e1c h\u00e0m n\u00e0y \u1edf phi\u00ean b\u1ea3n n\u00e2ng cao h\u01a1n, gi\u00fap \u00edch cho b\u1ea1n trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p h\u01a1n, \u0111\u00f3 l\u00e0 c\u00e1c h\u00e0m DSUM, DCOUNT, DAVERAGE.<\/p>\n

Trong c\u00e1c v\u00ed d\u1ee5 c\u1ee7a b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00ecnh minh ho\u1ea1 sau \u0111\u00e2y:<\/p>\n

\"ham-dsum-dcount-daverage-trong-excel\"<\/a><\/p>\n

Trong b\u1ea3ng t\u00ednh ph\u00eda tr\u00ean, ch\u00fang ta c\u00f3 v\u00f9ng d\u1eef li\u1ec7u A1:C6, v\u00f9ng d\u1eef li\u1ec7u n\u00e0y \u0111\u1ed1i v\u1edbi c\u00e1c h\u00e0m database trong Excel \u0111\u01b0\u1ee3c coi l\u00e0 m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u01a1 s\u1edf d\u1eef li\u1ec7u n\u00e0y g\u1ed3m c\u00f3 c\u00e1c c\u1ed9t v\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p to\u00e1n c\u1ed9ng, \u0111\u1ebfm, t\u00ednh trung b\u00ecnh tr\u00ean c\u00e1c c\u1ed9t c\u00f3 d\u1eef li\u1ec7u l\u00e0 s\u1ed1 \u2013 c\u1ed9t Amount trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y.<\/p>\n

C\u00e1c h\u00e0m c\u01a1 s\u1edf d\u1eef li\u1ec7u trong Excel trong b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec1u c\u00f3 chung 1 c\u1ea5u tr\u00fac cho c\u00e1c tham s\u1ed1:<\/p>\n

+ Tham s\u1ed1 \u0111\u1ea7u ti\u00ean: v\u00f9ng ch\u1ee9a d\u1eef li\u1ec7u<\/p>\n

+ Tham s\u1ed1 th\u1ee9 2: c\u1ed9t th\u1ef1c hi\u1ec7n ph\u00e9p t\u00ednh to\u00e1n c\u1ed9ng, trung b\u00ecnh, v\u00e0 ph\u00e9p \u0111\u1ebfm<\/p>\n

+ Tham s\u1ed1 th\u1ee9 3: v\u00f9ng \u0111i\u1ec1u ki\u1ec7n cho vi\u1ec7c t\u00ednh to\u00e1n<\/p>\n

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

Trong 3 v\u00ed d\u1ee5 tr\u00ean h\u00ecnh minh ho\u1ea1, ch\u00fang ta th\u1ea5y r\u1eb1ng:<\/p>\n

+ V\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 l\u00e0 \u0111\u1ea1i di\u1ec7n cho \u0111i\u1ec1u ki\u1ec7n trong 1 c\u1ed9t (G1:G2) v\u1edbi \u0111i\u1ec1u ki\u1ec7n l\u00e0 c\u00e1c d\u00f2ng c\u00f3 c\u1ed9t Amount l\u1edbn h\u01a1n 2000<\/p>\n

+ V\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p \u0111i\u1ec1u ki\u1ec7n nhi\u1ec1u c\u1ed9t trong c\u1ed9t database (G8:H9)<\/p>\n

+ V\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n AND ho\u1eb7c OR (G13:H15)<\/p>\n

Trong Excel, m\u1ed9t nh\u00f3m h\u00e0m c\u00f3 ch\u1ee9c n\u0103ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0 nh\u1eefng h\u00e0m c\u01a1 s\u1edf d\u1eef li\u1ec7u n\u00e0y l\u00e0 SUMIFS, SUMPRODUCT v\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i \u1edf nh\u1eefng b\u00e0i vi\u1ebft sau \u0111\u00e2y:<\/p>\n

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