{"id":302403,"date":"2024-01-04T15:17:38","date_gmt":"2024-01-04T08:17:38","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=302403"},"modified":"2025-12-25T22:11:53","modified_gmt":"2025-12-25T15:11:53","slug":"ham-dem-trong-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/ham-dem-trong-excel\/","title":{"rendered":"H\u00e0m \u0111\u1ebfm trong Excel: H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng COUNT, COUNTIF, COUNTA, COUNTIFS, COUNTBLANK"},"content":{"rendered":"

H\u00e0m \u0111\u1ebfm trong Excel (COUNT, COUNTIF, COUNTA, COUNTIFS, COUNTBLANK) l\u00e0 c\u00f4ng c\u1ee5 thi\u1ebft y\u1ebfu gi\u00fap x\u1eed l\u00fd d\u1eef li\u1ec7u nhanh ch\u00f3ng, ch\u00ednh x\u00e1c cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n, ph\u00e2n t\u00edch d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00fa ph\u00e1p, v\u00ed d\u1ee5 th\u1ef1c t\u1ebf t\u1eeb c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao, k\u00e8m h\u00ecnh minh h\u1ecda \u0111\u1ec3 b\u1ea1n \u00e1p d\u1ee5ng ngay.<\/span><\/p>\n

\u0110\u00f4i n\u00e9t v\u1ec1 c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel<\/span><\/h2>\n

\u0110\u1ec3 \u00e1p d\u1ee5ng hi\u1ec7u qu\u1ea3 c\u00e1c h\u00e0m \u0111\u1ebfm trong b\u1ea3ng t\u00ednh, tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n n\u1eafm b\u1eaft \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a v\u00e0 ph\u00e2n lo\u1ea1i c\u1ee7a ch\u00fang th\u00f4ng qua g\u1ee3i \u00fd sau:<\/span><\/p>\n

\u0110\u1ecbnh ngh\u0129a\u00a0<\/span><\/h3>\n

Trong Microsoft Excel, h\u00e0m \u0111\u1ebfm \u0111\u00f3ng vai tr\u00f2 quan tr\u1ecdng nh\u01b0 m\u1ed9t c\u00f4ng c\u1ee5 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng ph\u1ea7n t\u1eed trong m\u1ed9t d\u00e3y d\u1eef li\u1ec7u. H\u00e0m n\u00e0y kh\u00f4ng ch\u1ec9 gi\u00fap \u0111\u01a1n gi\u1ea3n h\u00f3a qu\u00e1 tr\u00ecnh th\u1ed1ng k\u00ea m\u00e0 c\u00f2n mang l\u1ea1i s\u1ef1 linh ho\u1ea1t v\u00e0 ch\u00ednh x\u00e1c khi l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c t\u1eadp d\u1eef li\u1ec7u l\u1edbn. Kh\u00f4ng d\u1eebng l\u1ea1i \u1edf \u0111\u00f3, c\u00e1c h\u00e0m \u0111\u1ebfm n\u00e0y c\u00f2n m\u1edf ra nhi\u1ec1u ti\u1ec7n \u00edch kh\u00e1c cho ng\u01b0\u1eddi d\u00f9ng th\u00f4ng qua kh\u1ea3 n\u0103ng nh\u01b0 \u0111\u1ebfm theo \u0111i\u1ec1u ki\u1ec7n hay \u0111\u1ebfm c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u kh\u00f4ng r\u1ed7ng.<\/span><\/p>\n

\"ham-dem-trong-excel-1\"<\/picture><\/p>\n

Th\u1ef1c t\u1ebf, vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel kh\u00f4ng ch\u1ec9 l\u00e0 k\u1ef9 n\u0103ng c\u1ea7n thi\u1ebft m\u00e0 c\u00f2n l\u00e0 y\u1ebfu t\u1ed1 quy\u1ebft \u0111\u1ecbnh \u0111\u1ebfn m\u1ee9c \u0111\u1ed9 hi\u1ec7u qu\u1ea3 c\u1ee7a qu\u00e1 tr\u00ecnh x\u1eed l\u00fd d\u1eef li\u1ec7u trong t\u1eebng nhi\u1ec7m v\u1ee5. Trong \u0111\u00f3, c\u00e1c nh\u00e2n vi\u00ean, nh\u00e0 qu\u1ea3n l\u00fd v\u00e0 nh\u1eefng ng\u01b0\u1eddi l\u00e0m c\u00f4ng vi\u1ec7c li\u00ean quan \u0111\u1ebfn d\u1eef li\u1ec7u \u0111\u1ec1u s\u1ebd c\u00f3 l\u1ee3i th\u1ebf r\u1ea5t l\u1edbn khi bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng nh\u1eefng h\u00e0m n\u00e0y \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 ch\u00ednh x\u00e1c th\u00f4ng tin. T\u1eeb \u0111\u00f3 gi\u00fap h\u1ecd \u0111\u01b0a ra c\u00e1c quy\u1ebft \u0111\u1ecbnh chi\u1ebfn l\u01b0\u1ee3c nhanh ch\u00f3ng v\u00e0 t\u1ed1i \u01b0u h\u00f3a quy tr\u00ecnh l\u00e0m vi\u1ec7c.<\/span><\/p>\n

Ph\u00e2n lo\u1ea1i c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel<\/span><\/h3>\n

Th\u1ef1c t\u1ebf, h\u00e0m \u0111\u1ebfm trong c\u00f4ng c\u1ee5 Excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng r\u1ea5t \u0111a d\u1ea1ng. Ch\u00fang c\u00f3 t\u1eadn 5 lo\u1ea1i kh\u00e1c nhau v\u00e0 t\u00f9y thu\u1ed9c v\u00e0o m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng m\u00e0 b\u1ea1n ch\u1ecdn m\u1ed9t h\u00e0m t\u00ednh ph\u00f9 h\u1ee3p. C\u1ee5 th\u1ec3, d\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c lo\u1ea1i h\u00e0m \u0111\u1ebfm trong b\u1ea3n t\u00ednh m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o.<\/span><\/p>\n\n\n\n\n\n\n\n\n\n
T\u00ean h\u00e0m<\/b><\/th>\nM\u00f4 t\u1ea3<\/b><\/th>\nC\u00fa ph\u00e1p c\u01a1 b\u1ea3n<\/b><\/p>\n

\u00a0<\/span><\/th>\n<\/tr>\n<\/thead>\n

COUNT<\/span><\/td>\n\u0110\u1ebfm s\u1ed1 \u00f4 ch\u1ee9a gi\u00e1 tr\u1ecb s\u1ed1 (kh\u00f4ng \u0111\u1ebfm ch\u1eef, \u00f4 tr\u1ed1ng)<\/span><\/td>\n=COUNT(range)<\/span><\/td>\n<\/tr>\n
COUNTIF<\/span><\/td>\n\u0110\u1ebfm theo 1 \u0111i\u1ec1u ki\u1ec7n (v\u00ed d\u1ee5: >100, “Nam”)<\/span><\/td>\n=COUNTIF(range, criteria)<\/span><\/td>\n<\/tr>\n
COUNTIFS<\/span><\/td>\n\u0110\u1ebfm theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n (t\u1ed1i \u0111a 127 c\u1eb7p \u0111i\u1ec1u ki\u1ec7n)<\/span><\/td>\n=COUNTIFS(range1, criteria1,\u2026)<\/span><\/td>\n<\/tr>\n
COUNTA<\/span><\/td>\n\u0110\u1ebfm t\u1ea5t c\u1ea3 \u00f4 kh\u00f4ng tr\u1ed1ng (s\u1ed1, ch\u1eef, ng\u00e0y th\u00e1ng)<\/span><\/td>\n=COUNTA(range)<\/span><\/td>\n<\/tr>\n
COUNTBLANK<\/span><\/td>\n\u0110\u1ebfm \u00f4 tr\u1ed1ng ho\u1eb7c ch\u1ee9a c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 r\u1ed7ng<\/span><\/td>\n=COUNTBLANK(range)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u1ee8ng d\u1ee5ng<\/span><\/h3>\n

H\u00e0m \u0111\u1ebfm trong Excel c\u00f3 nhi\u1ec1u \u1ee9ng d\u1ee5ng quan tr\u1ecdng trong vi\u1ec7c x\u1eed l\u00fd v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 \u1ee9ng d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a c\u00e1c h\u00e0m n\u00e0y m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o:<\/span><\/p>\n

H\u00e0m \u0111\u1ebfm gi\u00fap ng\u01b0\u1eddi d\u00f9ng th\u1ef1c hi\u1ec7n nhanh c\u00e1c th\u1ed1ng k\u00ea c\u01a1 b\u1ea3n nh\u01b0 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng, ph\u00e2n ph\u1ed1i v\u00e0 t\u1ef7 l\u1ec7 trong d\u1eef li\u1ec7u. T\u1eeb \u0111\u00f3, cung c\u1ea5p c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 k\u00edch th\u01b0\u1edbc c\u1ee7a d\u1eef li\u1ec7u v\u00e0 s\u1ef1 \u0111a d\u1ea1ng c\u1ee7a th\u00f4ng tin trong trang t\u00ednh.<\/span><\/p>\n

H\u00e0m t\u00ednh c\u0169ng gi\u00fap ki\u1ec3m tra s\u1ef1 \u0111\u1ea7y \u0111\u1ee7 ho\u1eb7c thi\u1ebfu s\u00f3t d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh. Ch\u00fang cho ph\u00e9p \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng m\u1ee5c th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3. T\u1eeb \u0111\u00f3 gi\u00fap ng\u01b0\u1eddi d\u00f9ng ph\u00e2n lo\u1ea1i v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u theo c\u00e1c ti\u00eau ch\u00ed nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n

\"ham-dem-trong-excel-2\"<\/picture><\/p>\n

H\u00e0m \u0111\u1ebfm c\u0169ng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 ki\u1ec3m so\u00e1t d\u1eef li\u1ec7u trong c\u00e1c b\u00e1o c\u00e1o v\u00e0 t\u1ed5ng h\u1ee3p th\u00f4ng tin quan tr\u1ecdng. H\u00e0m c\u00f3 kh\u1ea3 n\u0103ng th\u1ed1ng k\u00ea s\u1ed1 l\u01b0\u1ee3ng l\u1ed7i ho\u1eb7c v\u1ea5n \u0111\u1ec1 \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ch\u1ea5t l\u01b0\u1ee3ng c\u1ee7a d\u1ef1 \u00e1n. \u0110\u1ed3ng th\u1eddi h\u1ed7 tr\u1ee3 qu\u00e1 tr\u00ecnh ra quy\u1ebft \u0111\u1ecbnh d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u th\u1ed1ng k\u00ea ch\u00ednh x\u00e1c v\u00e0 c\u1ee5 th\u1ec3.<\/span><\/p>\n

Ngo\u00e0i ra, h\u00e0m n\u00e0y c\u00f2n \u0111\u01b0\u1ee3c t\u1eadn d\u1ee5ng ph\u1ed5 bi\u1ebfn trong l\u0129nh v\u1ef1c marketing khi ch\u00fang c\u00f3 th\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng l\u01b0\u1ee3t xem, nh\u1ea5p chu\u1ed9t ho\u1eb7c t\u01b0\u01a1ng t\u00e1c \u0111\u1ec3 \u0111\u00e1nh gi\u00e1 hi\u1ec7u su\u1ea5t chi\u1ebfn l\u01b0\u1ee3c ti\u1ebfp th\u1ecb. T\u1eeb \u0111\u00f3, gi\u00fap x\u00e1c \u0111\u1ecbnh m\u1ee9c \u0111\u1ed9 quan t\u00e2m v\u00e0 t\u01b0\u01a1ng t\u00e1c c\u1ee7a kh\u00e1ch h\u00e0ng v\u1edbi s\u1ea3n ph\u1ea9m ho\u1eb7c d\u1ecbch v\u1ee5 m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/span><\/p>\n

C\u00e1ch \u00e1p d\u1ee5ng c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel c\u01a1 b\u1ea3n d\u00e0nh cho b\u1ea1n<\/span><\/h2>\n

Th\u1ef1c ch\u1ea5t, c\u00e1c h\u00e0m \u0111\u1ebfm trong Excel c\u00f3 c\u00e1c thi\u1ebft l\u1eadp c\u1ea5u tr\u00fac t\u01b0\u01a1ng \u0111\u1ed1i \u0111\u01a1n gi\u1ea3n. Ch\u1ec9 c\u1ea7n b\u1ea1n x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u c\u1ee7a b\u00e0i to\u00e1n ho\u1eb7c nhi\u1ec7m v\u1ee5 v\u00e0 th\u1ef1c hi\u1ec7n theo h\u01b0\u1edbng d\u1eabn d\u01b0\u1edbi \u0111\u00e2y th\u00ec s\u1ebd th\u00e0nh c\u00f4ng.<\/span><\/p>\n

C\u00e1ch d\u00f9ng h\u00e0m COUNT<\/span><\/h3>\n

H\u00e0m COUNTIF \u0111\u1ebfm s\u1ed1 \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n c\u1ee5 th\u1ec3 (v\u00ed d\u1ee5: s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc sinh >8 \u0111i\u1ec3m, s\u1ea3n ph\u1ea9m t\u1ed3n kho “TXD”).<\/span><\/p>\n

C\u00fa ph\u00e1p:<\/b> =COUNTIF(range, criteria)<\/span><\/p>\n