{"id":5844,"date":"2024-12-21T08:19:15","date_gmt":"2024-12-21T08:19:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-ke-toan-ung-dung-ham-sumproduct-phan-2\/"},"modified":"2024-12-21T08:19:15","modified_gmt":"2024-12-21T08:19:15","slug":"excel-ke-toan-ung-dung-ham-sumproduct-phan-2","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/excel-ke-toan-ung-dung-ham-sumproduct-phan-2\/","title":{"rendered":"Excel k\u1ebf to\u00e1n: \u1ee8ng d\u1ee5ng h\u00e0m Sumproduct \u2013 Ph\u1ea7n 2"},"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 2: T\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<\/strong><\/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

\u0110\u1ec1 b\u00e0i:<\/strong><\/em> Cho b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb v\u00f9ng A1:E9, y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng ph\u00e1t sinh N\u1ee3 v\u00e0 ph\u00e1t sinh C\u00f3 theo th\u1eddi gian x\u00e1c\u00a0\u0111\u1ecbnh t\u1ea1i v\u00f9ng H3:H4, theo t\u00e0i kho\u1ea3n chi ti\u1ebft 1111 v\u00e0 t\u00e0i kho\u1ea3n t\u1ed5ng h\u1ee3p 111 (\u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c SUMPRODUCT)<\/p>\n

<\/p>\n

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

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

C\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n c\u1ea7n t\u00ednh:<\/p>\n