{"id":5810,"date":"2024-12-21T01:20:05","date_gmt":"2024-12-21T01:20:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-ke-toan-ung-dung-ham-sumproduct-phan-4\/"},"modified":"2024-12-21T01:20:05","modified_gmt":"2024-12-21T01:20:05","slug":"excel-ke-toan-ung-dung-ham-sumproduct-phan-4","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-ke-toan-ung-dung-ham-sumproduct-phan-4\/","title":{"rendered":"Excel k\u1ebf to\u00e1n: \u1ee8ng d\u1ee5ng h\u00e0m Sumproduct \u2013 Ph\u1ea7n 4"},"content":{"rendered":"
\n

H\u00f4m nay hocexcel.online g\u1eedi t\u1edbi c\u00e1c b\u1ea1n seri b\u00e0i vi\u1ebft v\u1ec1 ch\u1ee7 \u0111\u1ec1 Excel v\u1edbi k\u1ebf to\u00e1n: \u201c\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT<\/strong>\u201d. \u0110\u00e2y l\u00e0 m\u1ed9t h\u00e0m c\u00f3 s\u1ee9c m\u1ea1nh r\u1ea5t l\u1edbn, c\u00f3 th\u1ec3 thay th\u1ebf h\u1ea7u h\u1ebft m\u1ecdi h\u00e0m khi l\u00e0m k\u1ebf to\u00e1n tr\u00ean excel, hay n\u00f3i c\u00e1ch kh\u00e1c khi ngh\u0129 t\u1edbi l\u00e0m k\u1ebf to\u00e1n tr\u00ean excel l\u00e0 ch\u00fang ta ph\u1ea3i ngh\u0129 ngay t\u1edbi h\u00e0m SUMPRODUCT. T\u1ea1i sao n\u00f3 l\u1ea1i quan tr\u1ecdng nh\u01b0 v\u1eady? Sau \u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m SUMPRODUCT s\u1ebd r\u00f5.<\/p>\n

N\u1ed9i dung Seri b\u00e0i vi\u1ebft:<\/p>\n

Ph\u1ea7n 1: C\u1ea5u tr\u00fac h\u00e0m SUMPRODUCT,\u00a0\u1ee9ng d\u1ee5ng v\u00e0o vi\u1ec7c t\u00ednh t\u1ed5ng theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n, so s\u00e1nh v\u1edbi h\u00e0m SUMIFS<\/a><\/p>\n

Ph\u1ea7n 2:\u00a0T\u00ednh t\u1ed5ng ph\u00e1t sinh c\u1ee7a t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p d\u1ef1a tr\u00ean ghi s\u1ed5 c\u1ee7a t\u00e0i kho\u1ea3n chi ti\u1ebft<\/a><\/p>\n

Ph\u1ea7n 3:\u00a0\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT trong k\u1ebf to\u00e1n kho<\/a><\/p>\n

Ph\u1ea7n 4:\u00a0\u1ee8ng d\u1ee5ng h\u00e0m SUMPRODUCT trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng: x\u1eed l\u00fd d\u1eef li\u1ec7u m\u00e1y ch\u1ea5m c\u00f4ng<\/a><\/p>\n

\u2026.<\/p>\n

\u1ee8ng d\u1ee5ng 4:\u00a0\u1ee8ng d\u1ee5ng trong k\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng: X\u1eed l\u00fd d\u1eef li\u1ec7u m\u00e1y ch\u1ea5m c\u00f4ng v\u00e0o b\u1ea3ng ch\u1ea5m c\u00f4ng<\/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

B\u00e0i t\u1eadp:<\/strong><\/em><\/p>\n

Cho b\u1ea3ng d\u1eef li\u1ec7u tr\u00edch xu\u1ea5t t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng (ph\u1ea7n b\u00ean ph\u1ea3i h\u00ecnh, t\u1eeb c\u1ed9t AI\u00a0\u0111\u1ebfn AN)<\/p>\n

Y\u00eau c\u1ea7u: t\u1ef1\u00a0\u0111\u1ed9ng\u00a0\u0111\u01b0a d\u1eef li\u1ec7u c\u1ed9t ch\u1ea5m c\u00f4ng (AN) v\u00e0o b\u1ea3ng ch\u1ea5m c\u00f4ng th\u00e1ng 10\u00a0t\u01b0\u01a1ng\u00a0\u1ee9ng v\u1edbi t\u1eebng nh\u00e2n vi\u00ean theo t\u1eebng ng\u00e0y trong th\u00e1ng.<\/p>\n

<\/p>\n

C\u00e1ch l\u00e0m:<\/p>\n

B\u01b0\u1edbc 1: Ph\u00e2n t\u00edch\u00a0\u0111\u1ec1 b\u00e0i<\/p>\n

\u1ede b\u1ea3ng d\u1eef li\u1ec7u tr\u00edch xu\u1ea5t t\u1eeb m\u00e1y ch\u1ea5m c\u00f4ng ch\u00fang ta c\u00f3 c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng sau:<\/p>\n