{"id":5135,"date":"2024-12-09T10:25:05","date_gmt":"2024-12-09T10:25:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-sumproduct\/"},"modified":"2024-12-09T10:25:05","modified_gmt":"2024-12-09T10:25:05","slug":"4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-sumproduct","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/4-phuong-phap-dem-nhieu-dieu-kien-dang-hoac-ham-sumproduct\/","title":{"rendered":"4 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ebfm nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n d\u1ea1ng ho\u1eb7c \u2013 H\u00e0m SUMPRODUCT"},"content":{"rendered":"
\n

Vi\u1ec7c\u00a0\u0111\u1ebfm nh\u1eefng d\u1eef li\u1ec7u th\u1ecfa m\u00e3n theo m\u1ed9t v\u00e0i\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u1ea5t\u00a0\u0111\u1ecbnh trong\u00a0Excel l\u00e0 c\u00f4ng vi\u1ec7c ch\u00fang ta th\u01b0\u1eddng g\u1eb7p ph\u1ea3i khi l\u00e0m vi\u1ec7c. Nh\u01b0ng vi\u1ec7c \u201ct\u1eadp\u00a0\u0111\u1ebfm\u201d kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng d\u1ec5 l\u00e0m,\u00a0\u0111\u1eb7c bi\u1ec7t khi ph\u1ea3i\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. Trong ch\u00f9m b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc\u00a0Excel Online s\u1ebd gi\u1edbi thi\u1ec7u t\u1edbi c\u00e1c b\u1ea1n c\u00e1ch x\u1eed l\u00fd v\u1edbi vi\u1ec7c\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng HO\u1eb6C.\u00a0\u0110\u00e2y l\u00e0 d\u1ea1ng\u00a0\u0111i\u1ec1u ki\u1ec7n kh\u00f3 nh\u1ea5t trong vi\u1ec7c\u00a0\u0111\u1ebfm. Ch\u00fang ta s\u1ebd gi\u1ea3i quy\u1ebft y\u00eau c\u1ea7u n\u00e0y kh\u00f4ng ch\u1ec9 v\u1edbi 1 c\u00e1ch m\u00e0 c\u00f3 t\u1edbi 4 c\u00e1ch kh\u00e1c nhau. H\u00e3y c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1c c\u00e1ch n\u00e0y nh\u00e9:<\/p>\n

Y\u00eau c\u1ea7u c\u1ee7a ch\u00fang ta nh\u01b0 sau<\/strong>:<\/p>\n

Cho b\u1ea3ng d\u1eef li\u1ec7u:<\/p>\n

<\/p>\n

\u0110\u1ebfm S\u1ed1 ng\u01b0\u1eddi c\u00f3 gi\u1edbi t\u00ednh l\u00e0 nam c\u00f3 tu\u1ed5i t\u1eeb 20 tr\u1edf l\u00ean, ho\u1eb7c c\u00f3 s\u1ed1 th\u1ebb l\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng 50<\/p>\n

Ph\u01b0\u01a1ng ph\u00e1p th\u1ee9 4: S\u1eed d\u00f9ng h\u00e0m\u00a0SUMPRODUCT<\/h2>\n

H\u00e0m Sumproduct l\u00e0 1 h\u00e0m r\u1ea5t m\u1ea1nh trong vi\u1ec7c x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng m\u1ea3ng. Trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p th\u00ec h\u00e0m SUMPRODUCT c\u00f3 th\u1ec3 thay th\u1ebf\u00a0\u0111\u01b0\u1ee3c cho h\u00e0m SUMIF, SUMIFS, COUNTIF, COUNTIFS, DCOUNTA\u2026<\/p>\n

\u1ede nh\u1eefng b\u00e0i tr\u01b0\u1edbc ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m DCOUNTA, SUM+IF d\u1ea1ng\u00a0m\u1ea3ng, COUNTIFS\u00a0\u0111\u1ec3\u00a0\u0111\u1ebfm theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n. V\u1eady th\u00ec h\u00e0m SUMPRODUCT s\u1ebd s\u1eed d\u1ee5ng th\u1ebf n\u00e0o trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y? Ch\u00fang ta c\u00f9ng xem c\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n

D\u1ef1a theo logic\u00a0\u1edf b\u00e0i S\u1eed d\u1ee5ng h\u00e0m SUM +\u00a0IF d\u1ea1ng m\u1ea3ng<\/a>, ch\u00fang ta\u00a0\u0111\u00e3 c\u00f3 logic nh\u01b0 sau:<\/p>\n

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

(B2:B13=F4)+(C2:C13>=20)+(D2:D13>=50)<\/p>\n<\/blockquote>\n

Thay v\u00ec s\u1eed d\u1ee5ng d\u1ea1ng c\u00f4ng th\u1ee9c m\u1ea3ng trong h\u00e0m SUM, h\u00e0m\u00a0IF (b\u1edfi c\u00e1c h\u00e0m n\u00e0y kh\u00f4ng h\u1ed7\u00a0tr\u1ee3 v\u1edbi d\u1ea1ng m\u1ea3ng) th\u00ec ch\u00fang ta ho\u00e0n to\u00e0n\u00a0\u00e1p d\u1ee5ng\u00a0\u0111\u01b0\u1ee3c logic n\u00e0y trong h\u00e0m SUMPRODUCT m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c m\u1ea3ng. Ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c th\u01b0\u1eddng v\u1edbi h\u00e0m SUMPRODUCT.<\/p>\n

Tuy nhi\u00ean\u00a0\u1edf\u00a0\u0111\u00e2y, to\u00e0n b\u1ed9 logic n\u00e0y s\u1ebd\u00a0\u0111\u01b0\u1ee3c coi l\u00e0 1\u00a0ARRAY trong SUMPRODUCT, b\u1edfi m\u1ee5c\u00a0\u0111\u00edch l\u00e0\u00a0\u0110\u1ebeM theo nhi\u1ec1u\u00a0\u0111i\u1ec1u ki\u1ec7n d\u1ea1ng Ho\u1eb7c, do\u00a0\u0111\u00f3 v\u1eabn ph\u1ea3i gi\u1eef\u00a0\u0111\u01b0\u1ee3c logic l\u00e0 3 m\u1ea3ng c\u1ed9ng v\u1edbi nhau. N\u00ean trong SUMPRODUCT kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c t\u00e1ch r\u1eddi 3 m\u1ea3ng, m\u00e0 coi c\u1ea3 3 m\u1ea3ng c\u1ed9ng l\u1ea1i ch\u00ednh l\u00e0 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng m\u1ea3ng c\u1ee7a SUMPRODUCT. (N\u1ebfu t\u00e1ch ra 3 m\u1ea3ng l\u00e0 3\u00a0array ri\u00eang trong SUMPRODUCT th\u00ec s\u1ebd l\u00e0\u00a0\u0111i\u1ec1u ki\u1ec7n V\u00c0, kh\u00f4ng ph\u1ea3i\u00a0\u0111i\u1ec1u ki\u1ec7n HO\u1eb6C)<\/p>\n

* Ch\u00fa\u00a0\u00fd:<\/strong><\/p>\n