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

H\u00f4m nay blog.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 3: M\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng h\u00e0m SUMPRODUCT trong k\u1ebf to\u00e1n kho<\/strong><\/h2>\n

B\u00e0i t\u1eadp:<\/em><\/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

Cho b\u1ea3ng s\u1ed1 li\u1ec7u v\u1ec1 Nh\u1eadp-Xu\u1ea5t m\u1eb7t h\u00e0ng\u00a0\u0111i\u1ec7n tho\u1ea1i (v\u00f9ng A1:D11), y\u00eau c\u1ea7u t\u00ednh t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng Nh\u1eadp, Xu\u1ea5t trong th\u00e1ng 1 c\u1ee7a t\u1eebng m\u1eb7t h\u00e0ng (v\u00f9ng F2:H6) b\u1eb1ng h\u00e0m 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

Th\u00e1ng: G1 c\u00f3 th\u1ec3 thay\u00a0\u0111\u1ed5i gi\u00e1 tr\u1ecb cho c\u00e1c th\u00e1ng kh\u00e1c\u00a0\u0111\u01b0\u1ee3c.\u00a0\u1ede\u00a0\u0111\u00e2y x\u00e9t gi\u00e1 tr\u1ecb th\u00e1ng\u00a0 1, c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u th\u00e1ng l\u00e0 c\u1ed9t A<\/p>\n

T\u00ean h\u00e0ng:\u00a0\u00c1p d\u1ee5ng cho t\u1eebng lo\u1ea1i h\u00e0ng, x\u00e9t trong c\u1ed9t B<\/p>\n

Lo\u1ea1i h\u00ecnh:\u00a0\u00c1p d\u1ee5ng cho c\u1ed9t Lo\u1ea1i h\u00ecnh: Nh\u1eadp \/ xu\u1ea5t, x\u00e9t trong c\u1ed9t C<\/p>\n

\u0110\u1ed1i t\u01b0\u1ee3ng c\u1ea7n t\u00ednh l\u00e0 S\u1ed1 l\u01b0\u1ee3ng, c\u1ed9t D<\/p>\n

B\u01b0\u1edbc 2: X\u00e2y d\u1ef1ng n\u1ed9i dung h\u00e0m SUMPRODUCT<\/strong><\/p>\n

X\u00e9t t\u1ea1i\u00a0\u00f4 G3<\/p>\n