{"id":24207,"date":"2021-05-08T10:43:24","date_gmt":"2021-05-08T03:43:24","guid":{"rendered":"https:\/\/ben.com.vn\/tin-tuc\/?p=24207"},"modified":"2021-05-08T10:43:24","modified_gmt":"2021-05-08T03:43:24","slug":"ham-dsum-trong-excel","status":"publish","type":"post","link":"https:\/\/ben.com.vn\/tin-tuc\/ham-dsum-trong-excel\/","title":{"rendered":"C\u00fa ph\u00e1p H\u00e0m Dsum trong Excel v\u00e0 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng"},"content":{"rendered":"<p><strong>H\u00e0m Dsum trong Excel<\/strong> c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 h\u00e0m DATABASE Sum, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong tr\u01b0\u1eddng, c\u1ed9t trong danh s\u00e1ch d\u1eef li\u1ec7u th\u1ecfa m\u00e3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng <strong>h\u00e0m Dsum trong Excel<\/strong>.<\/p>\n<h2><strong>H\u00e0m Dsum trong Excel<\/strong><\/h2>\n<p><strong>H\u00e0m Dsum trong Excel<\/strong> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng v\u1edbi \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc trong m\u1ed9t c\u1ed9t hay tr\u01b0\u1eddng c\u1ee7a b\u1ea3ng t\u00ednh d\u1eef li\u1ec7u.<\/p>\n<figure id=\"attachment_24208\" aria-describedby=\"caption-attachment-24208\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" class=\"wp-image-24208 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-dsum-trong-excel.jpg\" alt=\"H\u00e0m Dsum trong Excel\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-dsum-trong-excel.jpg 640w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/05\/ham-dsum-trong-excel-300x169.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption id=\"caption-attachment-24208\" class=\"wp-caption-text\">H\u00e0m Dsum trong Excel<\/figcaption><\/figure>\n<h3><em><strong>C\u00fa ph\u00e1p h\u00e0m Dsum trong Excel<\/strong><\/em><\/h3>\n<p><strong>C\u00fa ph\u00e1p h\u00e0m Dsum trong Excel<\/strong> c\u00f3 d\u1ea1ng nh\u01b0 sau \u0111\u00e2y:<\/p>\n<blockquote><p><strong>=DSUM(database, field, criteria)<\/strong><\/p><\/blockquote>\n<p>Trong c\u00fa ph\u00e1p tr\u00ean, h\u00e0m Dsum s\u1eed d\u1ee5ng c\u00e1c tham s\u1ed1:<\/p>\n<p><strong>\u2013 Database<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u, b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u l\u00e0 c\u00e1c tr\u01b0\u1eddng, g\u1ed3m tr\u01b0\u1eddng \u0111\u1ec3 ki\u1ec3m tra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u01b0\u1eddng t\u00ednh t\u1ed5ng. Danh s\u00e1ch ch\u1ee9a h\u00e0ng \u0111\u1ea7u ti\u00ean l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t.<\/p>\n<p><strong>\u2013 Field<\/strong>\u00a0c\u0169ng l\u00e0 tham s\u1ed1 b\u1eaft bu\u1ed9c: l\u00e0 c\u1ed9t \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c d\u1eef li\u1ec7u t\u1ecfng b\u1ea3ng, v\u00f9ng d\u1eef li\u1ec7u h\u00e0m Dsum. Ch\u00fang ta c\u00f3 th\u1ec3 nh\u1eadp t\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t trong d\u1ea5u ngo\u1eb7c k\u00e9p ho\u1eb7c d\u00f9ng 1 s\u1ed1 th\u1ec3 hi\u1ec7n v\u1ecb tr\u00ed c\u1ed9t trong danh s\u00e1ch m\u00e0 kh\u00f4ng d\u00f9ng d\u1ea5u ngo\u1eb7c k\u00e9p hay tham chi\u1ebfu t\u1edbi ti\u00eau \u0111\u1ec1 c\u1ed9t mu\u1ed1n t\u00ednh t\u1ed5ng.<\/p>\n<p><strong>\u2013 Criteria<\/strong>\u00a0(tham s\u1ed1 b\u1eaft bu\u1ed9c): l\u00e0 d\u1ea3i \u00f4, v\u00f9ng \u00f4 ch\u1ee9a c\u00e1c ti\u00eau ch\u00ed hay \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1eb7t cho h\u00e0m \u0111\u1ec3 t\u00ednh to\u00e1n.<\/p>\n<p><strong>L\u01b0u \u00fd quan tr\u1ecdng:\u00a0<\/strong><\/p>\n<ul>\n<li>Ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u1ea1m vi b\u1ea5t k\u1ef3 cho tham s\u1ed1 criteria, mi\u00ea\u0303n la\u0300 no\u0301 co\u0301 ch\u01b0\u0301a i\u0301t nh\u00e2\u0301t m\u00f4\u0323t nha\u0303n c\u00f4\u0323t va\u0300 i\u0301t nh\u00e2\u0301t m\u00f4\u0323t \u00f4 b\u00ean d\u01b0\u01a1\u0301i nha\u0303n c\u00f4\u0323t \u0111\u00ea\u0309 xa\u0301c \u0111i\u0323nh \u0111i\u00ea\u0300u ki\u00ea\u0323n.<\/li>\n<li>M\u0103\u0323c du\u0300 pha\u0323m vi ti\u00eau chi\u0301 co\u0301 th\u00ea\u0309 \u0111\u01b0\u01a1\u0323c \u0111i\u0323nh vi\u0323 tr\u00ed b\u1ea5t k\u1ef3 tr\u00ean b\u1ea3ng t\u00ednh, tuy nhi\u00ean ch\u00fang ta kh\u00f4ng n\u00ean \u0111\u0103\u0323t pha\u0323m vi ti\u00eau chi\u0301 b\u00ean d\u01b0\u01a1\u0301i danh sa\u0301ch v\u00ec kh\u00f4ng c\u00f3 v\u1ecb tr\u00ed th\u00eam c\u00e1c th\u00f4ng tin kh\u00e1c v\u00e0o danh s\u00e1ch.<\/li>\n<\/ul>\n<h3><strong>C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Dsum trong Excel<\/strong><\/h3>\n<p>B\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u00ecm hi\u1ec3u <strong>c\u00e1ch s\u1eed d\u1ee5ng<\/strong> <strong>h\u00e0m Dsum trong Excel<\/strong>:<\/p>\n<h3><strong>V\u00ed d\u1ee5 1<\/strong><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y cho b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"552\" class=\"aligncenter wp-image-17487 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-32.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-32-300x240.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/1-32.jpg 691w\" alt=\"1 32 - H\u00e0m Dsum trong Excel - Ben Computer\" \/><\/p>\n<p>Y\u00eau c\u1ea7u l\u00e0 s\u1eed d\u1ee5ng h\u00e0m Dsum \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 b\u00e1n \u0111\u1ed3 ch\u01a1i trong qu\u00fd 3 v\u00e0 4. C\u00e1c ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n \u0111\u01b0a ra l\u00e0:<\/p>\n<p>Quarter: &gt;II<\/p>\n<p>Product: Soft toys<\/p>\n<p>Nh\u01b0 v\u1eady c\u00f4ng th\u1ee9c <strong>h\u00e0m Dsum Excel<\/strong> m\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng:\u00a0<strong>=DSUM(B4:E19,\u201dSales\u201d,H5:I6).<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"353\" class=\"aligncenter wp-image-17488 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-29.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-29-300x165.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/2-29.jpg 642w\" alt=\"2 29 - H\u00e0m Dsum trong Excel - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 h\u00e0m tr\u1ea3 v\u1ec1 l\u00e0 400.000.<\/p>\n<h3><strong>V\u00ed d\u1ee5 2<\/strong><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y y\u00eau c\u1ea7u l\u00e0 s\u1eed d\u1ee5ng <strong>h\u00e0m Dsum<\/strong> \u0111\u1ec3 t\u00ednh t\u1ed5ng doanh s\u1ed1 c\u00e1c m\u1ee5c l\u1edbn h\u01a1n 25.<\/p>\n<p>C\u00fa ph\u00e1p, <strong>c\u00f4ng th\u1ee9c h\u00e0m Dsum<\/strong> m\u00e0 ch\u00fang ta s\u1eed d\u1ee5ng c\u00f3 d\u1ea1ng nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"988\" height=\"465\" class=\"aligncenter wp-image-17489 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-18.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-18-300x141.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-18-768x361.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-18-750x353.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/3-18.jpg 988w\" alt=\"3 18 - H\u00e0m Dsum trong Excel - Ben Computer\" \/><\/p>\n<p>K\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 l\u00e0 15.609.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"927\" height=\"381\" class=\"aligncenter wp-image-17490 size-full\" src=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-15.jpg\" srcset=\"https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-15-300x123.jpg 300w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-15-768x316.jpg 768w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-15-750x308.jpg 750w, https:\/\/ben.com.vn\/tin-tuc\/wp-content\/uploads\/2021\/02\/4-15.jpg 927w\" alt=\"4 15 - H\u00e0m Dsum trong Excel - Ben Computer\" \/><\/p>\n<h3><strong>L\u01b0u \u00fd khi s\u1eed d\u1ee5ng h\u00e0m Dsum trong Excel<\/strong><\/h3>\n<p>Sau \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 l\u01b0u \u00fd quan tr\u1ecdng khi s\u1eed d\u1ee5ng <strong>h\u00e0m Dsum trong Excel<\/strong>:<\/p>\n<ul>\n<li>T\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1eb7t trong d\u1ea5u ngo\u1eb7c k\u00e9p v\u00e0 ph\u1ea3i gi\u1ed1ng t\u00ean ti\u00eau \u0111\u1ec1 b\u1ea3ng.<\/li>\n<li>H\u00e0m Dsum tr\u1ea3 v\u1ec1 l\u1ed7i #Value n\u1ebfu t\u00ean ti\u00eau \u0111\u1ec1 c\u1ed9t sai.<\/li>\n<li>N\u1ebfu kh\u00f4ng \u0111\u01b0a b\u1ea5t k\u1ef3 ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 n\u00e0o, h\u00e0m Dsum Excel tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 t\u1ed5ng gi\u00e1 tr\u1ecb c\u1ed9t.<\/li>\n<li>Ti\u00eau ch\u00ed, \u0111i\u1ec1u ki\u1ec7n h\u00e0m Dsum kh\u00f4ng ph\u00e2n bi\u1ec7t ch\u1eef hoa ch\u1eef th\u01b0\u1eddng.<\/li>\n<li>H\u00e0m Dsum c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf c\u00e1c h\u00e0m SUMIF &amp; SUMIFS trong Excel.<\/li>\n<\/ul>\n<p>\u0110\u1ebfn \u0111\u00e2y ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c c\u00fa ph\u00e1p c\u0169ng nh\u01b0 c\u00e1ch s\u1eed d\u1ee5ng<strong> h\u00e0m Dsum trong Excel<\/strong>. Nh\u00ecn chung <strong>h\u00e0m Dsum trong Excel<\/strong> c\u0169ng kh\u00f4ng qu\u00e1 kh\u00f3 s\u1eed d\u1ee5ng. Thao t\u00e1c v\u1edbi h\u00e0m kh\u00e1 \u0111\u01a1n gi\u1ea3n. \u0110\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb theo c\u1ed9t v\u1edbi \u0111i\u1ec1u ki\u1ec7n \u0111\u01a1n gi\u1ea3n, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Dsum, v\u1edbi \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Sumif.<\/p>\n<p>Ngo\u00e0i ra b\u1ea1n \u0111\u1ecdc c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft \u0111\u00e3 c\u00f3 tr\u00ean Ben Computer \u0111\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00e1ch s\u1eed d\u1ee5ng <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-sumif-trong-excel\/\">h\u00e0m Sumif<\/a> hay <a href=\"https:\/\/ben.com.vn\/tin-tuc\/ham-nhan-trong-excel\/\">h\u00e0m nh\u00e2n trong Excel<\/a> nh\u01b0 th\u1ebf n\u00e0o nh\u00e9. N\u1ebfu c\u00f2n th\u1eafc m\u1eafc ho\u1eb7c c\u00e2u h\u1ecfi n\u00e0o c\u1ea7n gi\u1ea3i \u0111\u00e1p th\u00eam, \u0111\u1eebng ng\u1ea7n ng\u1ea1i chia s\u1ebb \u00fd ki\u1ebfn, \u0111\u00f3ng g\u00f3p c\u1ee7a b\u1ea1n trong ph\u1ea7n b\u00ecnh lu\u1eadn b\u00ean d\u01b0\u1edbi b\u00e0i vi\u1ebft nh\u00e9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>H\u00e0m Dsum trong Excel c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 h\u00e0m DATABASE Sum, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong tr\u01b0\u1eddng, c\u1ed9t trong danh s\u00e1ch d\u1eef li\u1ec7u th\u1ecfa m\u00e3 c\u00e1c \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. Trong b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y Ben Computer s\u1ebd gi\u1edbi thi\u1ec7u cho b\u1ea1n c\u00fa ph\u00e1p v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Dsum trong [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":24208,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[10],"tags":[],"class_list":["post-24207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat-phan-mem"],"_links":{"self":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=24207"}],"version-history":[{"count":0,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/24207\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/24208"}],"wp:attachment":[{"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=24207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=24207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ben.com.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=24207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}