{"id":11288,"date":"2022-03-11T09:35:13","date_gmt":"2022-03-11T02:35:13","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11288"},"modified":"2022-03-20T22:40:31","modified_gmt":"2022-03-20T15:40:31","slug":"su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/su-dung-ham-dem-co-dieu-kien-sieu-don-gian-trong-excel\/","title":{"rendered":"S\u1eed d\u1ee5ng h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n si\u00eau \u0111\u01a1n gi\u1ea3n trong Excel\u00a0"},"content":{"rendered":"\n\n
\n \n
\n \n
\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n <\/div>\n \n
\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n
\n \n\n
<\/div>\n <\/div>\n <\/div>\n<\/div>\n \n\n
\n 5\/5 - (4 b\u00ecnh ch\u1ecdn) <\/div>\n <\/div>\n

Trong Excel, <\/span><\/span><\/span>h\u00e0m \u0111\u1ebfm c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/span><\/span><\/b><\/a> l\u00e0 m\u1ed9t trong nh\u1eefng ph\u00e9p to\u00e1n c\u01a1 b\u1ea3n m\u00e0 m\u1ed7i ng\u01b0\u1eddi s\u1eed d\u1ee5ng n\u00ean bi\u1ebft trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u. H\u00e0m \u0111\u1ebfm trong Excel c\u00f3 hai d\u1ea1ng c\u01a1 b\u1ea3n l\u00e0 COUNTIFS v\u00e0 COUNTIF. Ch\u00fang d\u1ec5 b\u1ecb nh\u1ea7m l\u1eabn b\u1edfi s\u1ef1 kh\u00e1c nhau kh\u00f4ng \u0111\u00e1ng k\u1ec3 v\u00e0 c\u00f3 c\u00f9ng m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng. B\u00e0i vi\u1ebft h\u00f4m nay kh\u00f4ng ch\u1ec9 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c hai h\u00e0m \u0111\u1ebfm tr\u00ean m\u00e0 c\u00f2n \u0111\u01b0a ra c\u00e1ch s\u1eed d\u1ee5ng ch\u00fang sao cho hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/span><\/span><\/span><\/p>\n

\n
\n

N\u1ed9i dung <\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n