{"id":10878,"date":"2025-01-15T00:27:03","date_gmt":"2025-01-15T00:27:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-ham-sumifs\/"},"modified":"2025-01-15T00:27:03","modified_gmt":"2025-01-15T00:27:03","slug":"ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-ham-sumifs","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/ham-cong-thuc-excel-su-dung-trong-ke-toan-tien-luong-nhan-su-ham-sumifs\/","title":{"rendered":"H\u00e0m, c\u00f4ng th\u1ee9c Excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, nh\u00e2n s\u1ef1: H\u00e0m SUMIFS"},"content":{"rendered":"
\n

Nh\u1eefng h\u00e0m, c\u00f4ng th\u1ee9c Excel n\u00e0o th\u01b0\u1eddng s\u1eed d\u1ee5ng trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, h\u00e0nh ch\u00ednh nh\u00e2n s\u1ef1<\/a>? N\u1ed9i dung n\u00e0y\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p qua b\u00e0i vi\u1ebft:\u00a0H\u00e0m, c\u00f4ng th\u1ee9c\u00a0excel s\u1eed d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng.<\/a><\/p>\n

Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u1ee5 th\u1ec3 c\u00e1ch\u00a0\u1ee9ng d\u1ee5ng c\u00e1c h\u00e0m\u00a0\u0111\u00f3 v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 th\u1ebf n\u00e0o nh\u00e9.<\/p>\n

B\u00e0i 6: H\u00e0m SUMIFS(sum_range, criteria_range1, criteria1, \u2026)<\/strong><\/p>\n

H\u00e0m SUMIFS l\u00e0 m\u1ed9t h\u00e0m c\u1ea5p cao h\u01a1n h\u00e0m SUMIF, v\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS\u00a0\u0111\u1ec3 t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac.<\/p>\n

H\u00e0m SUMIFS<\/strong><\/a> c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng\u00a0\u0111\u1ec3 thay th\u1ebf h\u00e0m SUMIF cho m\u1ecdi tr\u01b0\u1eddng h\u1ee3p, ngo\u00e0i ra c\u00f2n h\u1eefu d\u1ee5ng h\u01a1n SUMIF, n\u00ean\u00a0\u0111\u00e2y l\u00e0 h\u00e0m\u00a0\u0111\u1eb7c bi\u1ec7t h\u1eefu d\u1ee5ng trong m\u1ecdi c\u00f4ng vi\u1ec7c.<\/p>\n

Ch\u00fang ta c\u00f3 th\u1ec3 x\u00e9t t\u00ednh\u00a0\u1ee9ng d\u1ee5ng c\u1ee7a h\u00e0m SUMIFS trong tr\u01b0\u1eddng h\u1ee3p sau:<\/p>\n

<\/p>\n

Y\u00eau c\u1ea7u:<\/strong> T\u00ednh l\u01b0\u01a1ng th\u00e1ng 2 (ho\u1eb7c c\u00f3 th\u1ec3 t\u00f9y ch\u1ecdn t\u1ea1i\u00a0\u00f4 F2) v\u1edbi c\u00e1c nh\u00e2n vi\u00ean Long, B\u00ecnh, Ph\u00fa (ho\u1eb7c c\u00f3 th\u1ec3 t\u00f9y ch\u1ecdn t\u1ea1i v\u00f9ng E2:E4)<\/p>\n

\n
\n

D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n


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

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

X\u00e9t c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a y\u00eau c\u1ea7u\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m SUMIFS:<\/p>\n