{"id":12658,"date":"2015-09-07T10:33:01","date_gmt":"2015-09-07T10:33:01","guid":{"rendered":"https:\/\/centax.dsoftware.vn\/?p=12658"},"modified":"2015-09-29T09:22:19","modified_gmt":"2015-09-29T09:22:19","slug":"cach-su-dung-ham-sumif-trong-excel","status":"publish","type":"post","link":"https:\/\/centax.dsoftware.vn\/?p=12658","title":{"rendered":"C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Excel"},"content":{"rendered":"

\"C\u00e1ch<\/h2>\n

H\u00e0m Sumif l\u00e0 h\u00e0m t\u00ednh t\u1ed5ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng kh\u00e1 ph\u1ed5 bi\u1ebfn \u0111\u1ec3 l\u00e0m c\u00e1c c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n nh\u01b0: K\u1ebft chuy\u1ec3n c\u00e1c b\u00fat to\u00e1n cu\u1ed1i k\u1ef3, t\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u t\u1eeb Nh\u1eadt K\u00fd Chung l\u00ean b\u1ea3ng c\u00e2n \u0111\u1ed1i ph\u00e1t sinh\u2026<\/span><\/p>\n

T\u1ea1i b\u00e0i vi\u1ebft n\u00e0y, K\u1ebf to\u00e1n Centax<\/a><\/strong> xin h\u01b0\u1edbng d\u1eabn b\u1ea1n \u0111\u1ecdc c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif trong excel nh\u1eb1m thu\u1eadn ti\u1ec7n v\u00e0 \u0111\u01a1n gi\u1ea3n h\u00f3a vi\u1ec7c t\u00ednh to\u00e1n, k\u1ebft chuy\u1ec3n cu\u1ed1i k\u1ef3 k\u1ebf to\u00e1n.<\/span><\/p>\n

1. C\u00f4ng d\u1ee5ng c\u1ee7a h\u00e0m Sumif trong k\u1ebf to\u00e1n<\/span><\/strong><\/span><\/h2>\n

– K\u1ebft chuy\u1ec3n c\u00e1c b\u00fat to\u00e1n cu\u1ed1i k\u1ef3<\/span><\/p>\n

– T\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u t\u1eeb NKC l\u00ean Ph\u00e1t sinh N\u1ee3, Ph\u00e1t sinh C\u00f3 tr\u00ean b\u1ea3ng c\u00e2n \u0111\u1ed1i s\u1ed1 ph\u00e1t sinh th\u00e1ng v\u00e0 n\u0103m<\/span><\/p>\n

– T\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u t\u1eeb Phi\u1ebfu nh\u1eadp kho, Phi\u1ebfu xu\u1ea5t kho l\u00ean \u201cB\u1ea3ng Nh\u1eadp Xu\u1ea5t T\u1ed3n\u201d<\/span><\/p>\n

– T\u1ed5ng h\u1ee3p s\u1ed1 li\u1ec7u t\u1eeb NKC l\u00ean c\u1ed9t PS N\u1ee3, PS C\u00f3 c\u1eeda \u201c B\u1ea3ng t\u1ed5ng h\u1ee3p ph\u1ea3o thu, ph\u1ea3i tr\u1ea3 kh\u00e1ch h\u00e0ng\u201d<\/span><\/p>\n

\u2026<\/span><\/p>\n

2. C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Sumif<\/span><\/strong><\/span><\/h2>\n

C\u00fa ph\u00e1p:<\/strong><\/em> = Sumif( D\u00e3y \u00f4 \u0111i\u1ec1u ki\u1ec7n, \u0110i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh, D\u00e3y \u00f4 t\u00ednh t\u1ed5ng)<\/span><\/p>\n

Trong \u0111\u00f3:<\/span><\/p>\n

D\u00e3y \u00f4 \u0111i\u1ec1u ki\u1ec7n:<\/em> L\u00e0 d\u00e3y \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ebfn c\u1ea7n t\u00ednh<\/span><\/p>\n

V\u00ed d\u1ee5: L\u00e0 d\u00e3y \u00f4 ch\u1ee9a t\u00e0i kho\u1ea3n trong c\u1ed9t TK N\u1ee3\/TK c\u00f3, ho\u1eb7c d\u00e3y \u00f4 ch\u01b0a m\u00e3 h\u00e0ng c\u1ea7n t\u00ednh s\u1ed1 l\u01b0\u1ee3ng tr\u00ean phi\u1ebfu nh\u1eadp kho, xu\u1ea5t kho\u2026<\/span><\/p>\n

\u0110i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh:<\/em> Ph\u1ea3i c\u00f3 \u201ct\u00ean\u201d trong d\u00e3y \u00f4 \u0111i\u1ec1u ki\u1ec7n.<\/span><\/p>\n

V\u00ed d\u1ee5: L\u00e0 t\u00e0i kho\u1ea3n c\u1ea7n t\u00ednh tr\u00ean NKC, ho\u1eb7c m\u00e3 h\u00e0ng tr\u00ean kho<\/span><\/p>\n

D\u00e3y \u00f4 c\u1ea7n t\u00ednh t\u1ed5ng:<\/em> L\u00e0 d\u00e3y \u00f4 c\u1ea7n ch\u1ee9a gi\u00e1 tr\u1ecb trong c\u1ed9t ph\u00e1t sinh N\u1ee3 ho\u1eb7c ph\u00e1t sinh C\u00f3 tr\u00ean NKC, ho\u1eb7c d\u00e3y \u00f4 ch\u01b0a gi\u00e1 tr\u1ecb trong c\u1ed9t s\u1ed1 l\u01b0\u1ee3ng ho\u1eb7c th\u00e0nh ti\u1ec1n<\/span><\/p>\n

D\u00e3y \u00f4 \u0111i\u1ec1u ki\u1ec7n v\u00e0 d\u00e3y \u00f4 t\u00ednh t\u1ed5ng ph\u1ea3i t\u01b0\u01a1ng \u1ee9ng nhau,<\/span><\/p>\n

H\u01b0\u1edbng d\u1eabn khi mu\u1ed1n tuy\u1ec7t\u00a0\u0111\u1ed1i d\u00f2ng ho\u1eb7c c\u1ed9t ( vi\u1ec7c n\u00e0y l\u00e0 t\u00f9y t\u1eebng tr\u01b0\u1eddng h\u1ee3p)<\/p>\n

\"C\u00e1ch<\/p>\n

– B\u1ea5m F4 (1 l\u1ea7n): <\/strong>\u0110\u1ec3 c\u00f3 gi\u00e1\u00a0tr\u1ecb tuy\u1ec7t \u0111\u1ed1i ( tuy\u1ec7t \u0111\u1ed1i \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t v\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u2013 ($c\u1ed9t$d\u00f2ng); V\u00ed d\u1ee5: $A$10 \u2013 t\u1ee9c l\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t A v\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng 10<\/span><\/p>\n

– B\u1ea5m F4 (2 l\u1ea7n):<\/strong> \u0110\u1ec3 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i c\u1ed9t v\u00e0 tuy\u1ec7t \u0111\u1ed1i d\u00f2ng \u2013 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u1ed1 \u0111\u1ecbnh d\u00f2ng thay \u0111\u1ed5i c\u1ed9t \u2013 (c\u1ed9t$d\u00f2ng) ; V\u00ed d\u1ee5: A$10 \u2013 t\u1ee9c l\u00e0 c\u1ed1 \u0111\u1ecbnh D\u00f2ng 10, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh c\u1ed9t A<\/span><\/p>\n

– B\u1ea5m F4( 3l\u1ea7n): <\/strong>\u0110\u1ec3 c\u00f3 gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u0111\u1ed1i d\u00f2ng v\u00e0 tuy\u1ec7t \u0111\u1ed1i c\u1ed9t \u2013 \u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 c\u1ed1 \u0111\u1ecbnh c\u1ed9t thay \u0111\u1ed5i d\u00f2ng \u2013 ($c\u1ed9t d\u00f2ng) ; V\u00ed d\u1ee5: $A10 \u2013 t\u1ee9c l\u00e0 c\u1ed1 \u0111\u1ecbnh C\u1ed9t A, kh\u00f4ng c\u1ed1 \u0111\u1ecbnh d\u00f2ng 10<\/span>.<\/span><\/p>\n

V\u00ed d\u1ee5:<\/span><\/p>\n

\"C\u00e1ch<\/span><\/p>\n

\u0110\u01b0\u1ee3c bi\u1ebft nh\u1eefng nh\u00e2n vi\u00ean l\u00e0m\u00a0\u0111\u1ee7 26\/26 ng\u00e0y c\u00f4ng th\u00ec\u00a0\u0111\u01b0\u1ee3c th\u01b0\u1edfng chuy\u00ean c\u1ea7n 500.000\u00a0\u0111\u1ed3ng<\/span><\/p>\n

V\u1eady,\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n chuy\u00ean c\u1ea7n m\u00e0 c\u00f4ng ty\u00a0\u0111\u00e3 th\u01b0\u1edfng cho nh\u00e2n vi\u00ean, t\u1ea1i\u00a0\u00f4 F15 ta\u00a0\u0111\u1eb7t c\u00f4ng th\u1ee9c:<\/span><\/p>\n

= SUMIF( E4:E13,26,F4:F13)\u00a0<\/span><\/p>\n

T\u1ee9c l\u00e0 t\u00ecm trong c\u1ed9t t\u1eeb E4\u00a0\u0111\u1ebfn E13,\u00a0\u00f4 26, gi\u00f3ng sang c\u1ed9t F4:F13\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n t\u01b0\u01a1ng\u00a0\u1ee9ng<\/span><\/p>\n

M\u1eddi b\u1ea1n\u00a0\u0111\u1ecdc tham kh\u1ea3o th\u00eam c\u00e1c b\u00e0i vi\u1ebft sau:<\/span><\/p>\n

T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m Excel hay d\u00f9ng trong k\u1ebf to\u00e1n<\/a><\/span><\/p>\n

Ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n Excel<\/a><\/span><\/p>\n

C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m IF trong Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

K\u1ebf to\u00e1n Centax xin h\u01b0\u1edbng d\u1eabn b\u1ea1n \u0111\u1ecdc C\u00e1ch s\u1eed d\u1ee5ng h\u00e0m SUMIF trong Excel, m\u1ed9t trong nh\u1eefng h\u00e0m th\u00f4ng d\u1ee5ng trong c\u00f4ng t\u00e1c k\u1ebf to\u00e1n Excel. M\u1eddi b\u1ea1n \u0111\u1ecdc tham kh\u1ea3o<\/p>\n","protected":false},"author":7,"featured_media":12732,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"tags":[1574],"_links":{"self":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12658"}],"collection":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12658"}],"version-history":[{"count":0,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/posts\/12658\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=\/wp\/v2\/media\/12732"}],"wp:attachment":[{"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12658"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/centax.dsoftware.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}