{"id":7634,"date":"2021-08-13T11:22:08","date_gmt":"2021-08-13T04:22:08","guid":{"rendered":"https:\/\/tct.vn\/blog\/?p=7634"},"modified":"2021-08-18T11:08:28","modified_gmt":"2021-08-18T04:08:28","slug":"6-ham-thuong-dung-trong-nghiep-vu-ke-toan-kiem-toan","status":"publish","type":"post","link":"https:\/\/tct.vn\/blog\/6-ham-thuong-dung-trong-nghiep-vu-ke-toan-kiem-toan\/","title":{"rendered":"6 h\u00e0m th\u01b0\u1eddng d\u00f9ng trong nghi\u1ec7p v\u1ee5 k\u1ebf to\u00e1n ki\u1ec3m to\u00e1n"},"content":{"rendered":"<p>Excel l\u00e0 c\u00f4ng c\u1ee5 l\u00e0m vi\u1ec7c g\u1ea7n nh\u01b0 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 v\u1edbi k\u1ebf to\u00e1n v\u00e0 ki\u1ec3m to\u00e1n. \u0110\u00e2y c\u0169ng l\u00e0 c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c gi\u00fap k\u1ebf to\u00e1n v\u00e0 ki\u1ec3m to\u00e1n vi\u00ean ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng nh\u1ea5t. H\u1ecdc Vi\u1ec7n APT gi\u1edbi thi\u1ec7u 6 h\u00e0m th\u01b0\u1eddng d\u00f9ng nh\u1ea5t trong nghi\u1ec7p v\u1ee5 k\u1ebf to\u00e1n ki\u1ec3m to\u00e1n.<strong>\u00a0<\/strong><\/p>\n<p><strong>1. H\u00c0M T\u00cdNH T\u1ed4NG (SUMPRODUCT, SUMIF, SUMIFS)<\/strong><\/p>\n<p><strong>a. H\u00e0m SUMPRODUCT<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p:\u00a0<\/strong>= SUMPRODUCT(m\u1ea3ng 1,m\u1ea3ng 2, \u2026,m\u1ea3ng n)<\/p>\n<p><strong>C\u00f4ng d\u1ee5ng:\u00a0<\/strong>Nh\u00e2n ca\u0301c tha\u0300nh ph\u00e2\u0300n t\u01b0\u01a1ng \u01b0\u0301ng trong ca\u0301c ma\u0309ng \u0111a\u0303 cho va\u0300 tra\u0309 v\u00ea\u0300 t\u00f4\u0309ng cu\u0309a ca\u0301c ti\u0301ch s\u00f4\u0301 na\u0300y.<\/p>\n<p><strong>L\u01b0u \u00fd:<\/strong><\/p>\n<ul>\n<li>Ca\u0301c \u0111\u00f4\u0301i s\u00f4\u0301 ma\u0309ng pha\u0309i co\u0301 cu\u0300ng ki\u0301ch th\u01b0\u01a1\u0301c. N\u00ea\u0301u kh\u00f4ng, ha\u0300m SUMPRODUCT tra\u0309 v\u00ea\u0300 gia\u0301 tri\u0323 l\u00f4\u0303i #VALUE!<\/li>\n<li>Ha\u0300m SUMPRODUCT coi ca\u0301c mu\u0323c cu\u0309a ma\u0309ng kh\u00f4ng co\u0301 da\u0323ng s\u00f4\u0301 la\u0300 s\u00f4\u0301 kh\u00f4ng.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: T\u1ed5ng VAT = 1,000,000 *5% + 2,000,000*10% + 3,000,000 *15%<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7636\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham1.jpg\" alt=\"\" width=\"782\" height=\"127\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham1.jpg 782w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham1-400x65.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham1-768x125.jpg 768w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham1-510x83.jpg 510w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/p>\n<p><strong>b. H\u00e0m SUMIF<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p<\/strong>: =SUMIF(<strong>V\u00f9ng \u0111i\u1ec1u ki\u1ec7n,\u0110i\u1ec1u ki\u1ec7n,V\u00f9ng t\u00ednh t\u1ed5ng<\/strong>)<\/p>\n<p><strong>C\u00f4ng d\u1ee5ng<\/strong>: T\u00ednh t\u1ed5ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb s\u1ed1 trong v\u00f9ng t\u00ednh t\u1ed5ng m\u00e0 c\u00f3 \u00f4 t\u01b0\u01a1ng \u1ee9ng c\u00f9ng m\u1ed9t h\u00e0ng thu\u1ed9c v\u00f9ng \u0111i\u1ec1u ki\u1ec7n th\u1ecfa \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7t ra. \u0110i\u1ec1u ki\u1ec7n ph\u1ea3i \u0111\u01b0\u1ee3c mi\u00eau t\u1ea3 d\u01b0\u1edbi d\u1ea1ng chu\u1ed7i (\u0111\u1eb7t \u0111i\u1ec1u ki\u1ec7n trong \u201cd\u1ea5u ngo\u1eb7c k\u00e9p\u201d) v\u00e0 b\u1eaft \u0111\u1ea7u b\u1edfi c\u00e1c to\u00e1n t\u1eed &gt;,&gt;=,&lt;,&lt;=,=,&lt;&gt;.<\/p>\n<p><strong><u>L\u01b0u \u00fd:<\/u><\/strong><\/p>\n<ul>\n<li>N\u1ebfu v\u00f9ng \u0111i\u1ec1u ki\u1ec7n tr\u00f9ng v\u1edbi v\u00f9ng t\u00ednh t\u1ed5ng, ch\u00fang ta ch\u1ec9 kh\u00f4ng c\u1ea7n ph\u1ea3i nh\u1eadp v\u00f9ng t\u00ednh t\u1ed5ng v\u00e0o c\u00f4ng th\u1ee9c. Khi \u0111\u00f3, c\u00fa ph\u00e1p c\u1ee7a h\u00e0m SUMIF s\u1ebd tr\u1edf th\u00e0nh nh\u01b0 sau: C\u00fa ph\u00e1p: =SUMIF(V\u00f9ng \u0111i\u1ec1u ki\u1ec7n,\u0110i\u1ec1u ki\u1ec7n).\u00a0<em>V\u00ed d\u1ee5: t\u00ednh t\u1ed5ng doanh s\u1ed1 kh\u00e1ch h\u00e0ng doanh thu tr\u00ean 1 t\u1ef7.<\/em><em>\u00a0<\/em><\/li>\n<\/ul>\n<p><strong>c. H\u00e0m SUMIFS<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p: =<\/strong>SUMIFS<strong>(V\u00f9ng t\u00ednh t\u1ed5ng, v\u00f9ng \u0111i\u1ec1u ki\u1ec7n 1, \u0111i\u1ec1u ki\u1ec7n 1, v\u00f9ng \u0111i\u1ec1u ki\u1ec7n n, \u0111i\u1ec1u ki\u1ec7n n)<\/strong><\/p>\n<p><strong>C\u00f4ng d\u1ee5ng:\u00a0<\/strong>T\u00ednh t\u1ed5ng theo 1 ho\u1eb7c nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/p>\n<p><strong>L\u01b0u \u00fd:\u00a0<\/strong>Sumifs c\u00f3 nhi\u1ec1u \u01b0u \u0111i\u1ec3m h\u01a1n Sumif: tr\u1ea3 v\u1ec1 v\u00f9ng d\u1eef li\u1ec7u sum khi l\u00e0m truy so\u00e1t, (<strong>Ctrl+[<\/strong>), thao t\u00e1c tr\u00ean c\u00f9ng m\u1ed9t worksheet<strong>\u00a0<\/strong><\/p>\n<p><strong>2. H\u00c0M D\u00d2 T\u00ccM (VLOOKUP, HLOOKUP)<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p:<\/strong>\u00a0= VLOOKUP(<strong>Gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm,B\u1ea3ng d\u00f2 t\u00ecm,S\u1ed1 th\u1ee9 t\u1ef1 c\u1ed9t d\u00f2 t\u00ecm,Ki\u1ec3u d\u00f2 t\u00ecm<\/strong>)<\/p>\n<p><strong>C\u00f4ng d\u1ee5ng:<\/strong>\u00a0T\u00ecm ki\u1ebfm gi\u00e1 tr\u1ecb t\u1eeb b\u1ea3ng d\u00f2 t\u00ecm theo chi\u1ec1u d\u1ecdc.<\/p>\n<ul>\n<li>Ki\u1ec3u d\u00f2 t\u00ecm = 0 ho\u1eb7c FALSE: d\u00f2 t\u00ecm ch\u00ednh x\u00e1c, n\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/li>\n<li>Ki\u1ec3u d\u00f2 t\u00ecm = 1 ho\u1eb7c TRUE: d\u00f2 t\u00ecm g\u1ea7n \u0111\u00fang, khi \u0111\u00f3 h\u00e0m s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t g\u1ea7n b\u1eb1ng gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm nh\u01b0ng nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb d\u00f2 t\u00ecm. D\u1eef li\u1ec7u \u1edf c\u1ed9t d\u00f2 t\u00ecm ph\u1ea3i \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n.<\/li>\n<li>Ng\u01b0\u1ee3c l\u1ea1i v\u1edbi h\u00e0m VLOOKUP l\u00e0 h\u00e0m HLOOKUP (Horizontal lookup), t\u1ee9c l\u00e0 d\u00f2 t\u00ecm theo chi\u1ec1u ngang.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5: hlookup = 100 &amp; vlookup = 100<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7637\" src=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham2-1024x140-1.jpg\" alt=\"\" width=\"1024\" height=\"140\" srcset=\"https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham2-1024x140-1.jpg 1024w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham2-1024x140-1-400x55.jpg 400w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham2-1024x140-1-800x109.jpg 800w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham2-1024x140-1-768x105.jpg 768w, https:\/\/tct.vn\/blog\/wp-content\/uploads\/2021\/08\/ham2-1024x140-1-510x70.jpg 510w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><strong>3. H\u00c0M X\u1eec L\u00dd CHU\u1ed6I (LEFT, RIGHT, MID, LEN, TRIM)<\/strong><\/p>\n<p><strong>a. H\u00e0m MID()<\/strong><\/p>\n<p>\u2013 C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m Mid() trong Excel\u00a0<strong>MID<\/strong>(<strong>Chu\u1ed7i ,V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u, [S\u1ed1 k\u00fd t\u1ef1]<\/strong>)<\/p>\n<p>\u2013 C\u00f4ng d\u1ee5ng: H\u00e0m Mid() d\u00f9ng \u0111\u1ec3 l\u1ea5y ra n k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i (Text) t\u1eeb ngay v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh Gi\u1ea3i th\u00edch:<\/p>\n<ul>\n<li><strong>Chu\u1ed7i<\/strong>: L\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 c\u1ea7n l\u1ea5y ra.<\/li>\n<li><strong>V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u<\/strong>: V\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u \u0111\u1ec3 l\u1ea5y n k\u00fd t\u1ef1 t\u1eeb trong chu\u1ed7i \u0111\u00e3 cho<\/li>\n<li><strong>S\u1ed1 k\u00fd t\u1ef1<\/strong>: L\u00e0 s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y ra t\u1eeb ngay v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u c\u1ee7a Chu\u1ed7i \u0111\u00e3 cho.<\/li>\n<\/ul>\n<p>\u2013 V\u00ed d\u1ee5<\/p>\n<p>Mid(\u201cExcel thuc hanh kiem toan\u201d,7,9) = thuc hanh<\/p>\n<p><em>H\u00e0m Mid() s\u1ebd l\u1ea5y ra 9 k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u l\u00e0 s\u1ed1 7 (ch\u1eef t) c\u1ee7a chu\u1ed7i \u201cExcel thuc hanh kiem toan\u201d.<\/em><\/p>\n<p><strong>b. H\u00e0m LEN()<\/strong><\/p>\n<p><strong>\u2013 C\u1ea5u tr\u00fac: =LEN(Chu\u1ed7i)<\/strong><\/p>\n<p><strong>\u2013 Ch\u1ee9c n\u0103ng:\u00a0<\/strong>H\u00e0m Len() d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm chi\u1ec1u d\u00e0i (s\u1ed1 k\u00fd t\u1ef1) c\u1ee7a chu\u1ed7i (Text)<\/p>\n<p><strong><em>Gi\u1ea3i th\u00edch:<\/em><\/strong><\/p>\n<ul>\n<li><strong><em>Chu\u1ed7i:\u00a0<\/em><\/strong><em>L\u00e0 chu\u1ed7i v\u0103n b\u1ea3n c\u00f3 ch\u1ee9a c\u00e1c k\u00fd t\u1ef1 c\u1ea7n \u0111\u1ebfm t\u1ed5ng chi\u1ec1u d\u00e0i bao nhi\u00eau k\u00fd t\u1ef1.<\/em><\/li>\n<\/ul>\n<p><strong>\u2013 V\u00ed d\u1ee5<\/strong><\/p>\n<p><strong>Len<\/strong>(\u201cZaloPay\u201d) = 7<\/p>\n<p>H\u00e0m Len() s\u1ebd \u0111\u1ebfm t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 c\u1ee7a chu\u1ed7i \u201cZaloPay\u201d.<\/p>\n<p><strong>c. H\u00e0m LEFT()<\/strong><\/p>\n<p><strong>\u2013 C\u1ea5u tr\u00fac: =LEFT (chu\u1ed7i, s\u1ed1 k\u00fd t\u1ef1)<\/strong><\/p>\n<p><strong>\u2013 Ch\u1ee9c n\u0103ng: \u0111\u1ec3 l\u1ea5y ra k\u00fd t\u1ef1 b\u00ean tr\u00e1i chu\u1ed7i<\/strong><\/p>\n<p><strong>\u2013 V\u00ed d\u1ee5:<\/strong><\/p>\n<p><strong>=Left(\u201cZALOPAY\u201d,4)=ZALO<\/strong><\/p>\n<p><strong>d. H\u00e0m MID<\/strong><\/p>\n<ul>\n<li>\u2013\u00a0<strong>C\u1ea5u tr\u00fac:\u00a0<\/strong>=MID<strong>(chu\u1ed7i,s\u1ed1 k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u, t\u1ed5ng s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y)<\/strong><\/li>\n<li>\u2013\u00a0<strong>Ch\u1ee9c n\u0103ng:\u00a0<\/strong>l\u1ea5y c\u00e1c k\u00fd t\u1ef1 n\u1eb1m \u00ab\u00a0gi\u1eefa\u00a0\u00bb chu\u1ed7i<\/li>\n<li>\u2013\u00a0<strong>V\u00ed d\u1ee5:<\/strong><\/li>\n<\/ul>\n<p>=MID(\u201c2018\/05\/19\u201d,6,2)\u00a0 s\u1ebd tr\u1ea3 k\u1ebft qu\u1ea3 l\u00e0 05<strong>\u00a0<\/strong><\/p>\n<p><strong>e. H\u00e0m TRIM<\/strong><\/p>\n<p><strong>\u2013 C\u1ea5u tr\u00fac:\u00a0<\/strong>=TRIM<strong>(chu\u1ed7i k\u00fd t\u1ef1)<\/strong><\/p>\n<p><strong>\u2013 Ch\u1ee9c n\u0103ng:\u00a0<\/strong>Lo\u1ea1i b\u1ecf c\u00e1c kho\u1ea3ng tr\u1eafng th\u1eeba trong chu\u1ed7i.<\/p>\n<p><strong>\u2013 V\u00ed d\u1ee5:<\/strong><\/p>\n<p>=TRIM(\u201c Zalo Pay \u201d) s\u1ebd cho k\u1ebft qu\u1ea3 l\u00e0 ZaloPay.<strong>\u00a0<\/strong><\/p>\n<p><strong>5. H\u00c0M \u0110I\u1ec0U KI\u1ec6N (IF, IFERROR)<\/strong><strong>\u00a0<\/strong><\/p>\n<p><strong>a. H\u00e0m IF<\/strong><\/p>\n<p><strong>C\u00fa Ph\u00e1p<\/strong>:\u00a0<strong>IF (\u0111i\u1ec1u ki\u1ec7n, gi\u00e1 tr\u1ecb 1, gi\u00e1 tr\u1ecb 2)<\/strong><\/p>\n<p><strong>\u00dd Ngh\u0129a<\/strong>: N\u1ebfu nh\u01b0 \u201c<strong>\u0111i\u1ec1u ki\u1ec7n<\/strong>\u201d \u0111\u00fang th\u00ec k\u1ebft qu\u1ea3 h\u00e0m tr\u1ea3 v\u1ec1 l\u00e0 \u201c<strong>gi\u00e1 tr\u1ecb 1<\/strong>\u201d, ng\u01b0\u1ee3c l\u1ea1i tr\u1ea3 v\u1ec1 \u201c<strong>gi\u00e1 tr\u1ecb 2<\/strong>\u201d.<\/p>\n<p><strong>b. H\u00e0m IFERROR<\/strong><\/p>\n<p>C\u00fa ph\u00e1p: = IFERROR(<strong>gi\u00e1 tr\u1ecb, gi\u00e1 tr\u1ecb n\u1ebfu l\u1ed7i<\/strong>)<\/p>\n<p>C\u00f4ng d\u1ee5ng: N\u1ebfu bi\u1ec3u th\u1ee9c gi\u00e1 tr\u1ecb kh\u00f4ng t\u1ea1o ra m\u1ed9t l\u1ed7i, IFERROR() tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 c\u1ee7a bi\u1ec3u th\u1ee9c; c\u00f2n n\u1ebfu kh\u00f4ng, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb n\u1ebfu l\u1ed7i (l\u00e0 chu\u1ed7i r\u1ed7ng ho\u1eb7c m\u1ed9t th\u00f4ng b\u00e1o l\u1ed7i).<strong>\u00a0<\/strong><\/p>\n<p><strong>c. K\u1ebft h\u1ee3p IFERROR v\u00e0 VLOOKUP<\/strong><strong>\u00a0<\/strong><\/p>\n<p><strong>=IFERROR(VLOOKUP(gi\u00e1 tr\u1ecb t\u00ecm, v\u00f9ng t\u00ecm 1, s\u1ed1 c\u1ed9t t\u00ecm 1,0),VLOOKUP(gi\u00e1 tr\u1ecb t\u00ecm, v\u00f9ng t\u00ecm 2, s\u1ed1 c\u1ed9t t\u00ecm 2,0)<\/strong><strong>\u00a0<\/strong><\/p>\n<p><strong>6. H\u00c0M \u0110\u1ebeM D\u1eee LI\u1ec6U (COUNT, COUNTA, COUNTIF)<\/strong><\/p>\n<p><strong>a. H\u00e0m COUNT<\/strong><\/p>\n<p><strong>\u2013 C\u00fa ph\u00e1p: COUNT(Value1, Value2, \u2026)<\/strong><\/p>\n<p><strong>\u2013 Ch\u1ee9c n\u0103ng:<\/strong>\u00a0H\u00e0m n\u00e0y d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a\u00a0<strong>d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1\u00a0<\/strong>trong d\u00e3y<\/p>\n<p>V\u1edbi c\u00e1c tham s\u1ed1: Value1, Value2\u2026 l\u00e0 m\u1ea3ng hay d\u00e3y d\u1eef li\u1ec7u.<strong>\u00a0<\/strong><\/p>\n<p><strong>b. H\u00e0m COUNTA<\/strong><\/p>\n<p><strong>\u2013 C\u00fa ph\u00e1p: COUNTA(Value1, Value2, \u2026)<\/strong><\/p>\n<p>\u2013\u00a0<strong>Ch\u1ee9c n\u0103ng:<\/strong>\u00a0\u0110\u1ebfm t\u1ea5t c\u1ea3 c\u00e1c \u00f4 ch\u1ee9a\u00a0<strong>d\u1eef li\u1ec7u<\/strong>.<\/p>\n<p><strong>c. H\u00e0m COUNTIF<\/strong><\/p>\n<p><strong>C\u00fa ph\u00e1p: COUNTIF(Range, Criteria)<\/strong><\/p>\n<p><strong>Ch\u1ee9c n\u0103ng:<\/strong>\u00a0H\u00e0m n\u00e0y c\u00f3 ch\u1ee9c n\u0103ng \u0111\u1ebfm c\u00e1c \u00f4 ch\u1ee9a\u00a0<strong>d\u1eef li\u1ec7u ki\u1ec3u s\u1ed1\u00a0<\/strong>theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n cho tr\u01b0\u1edbc.<\/p>\n<p>C\u00e1c tham s\u1ed1: \u2013 Range: D\u00e3y d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm. \u2013 Criteria: L\u00e0 ti\u00eau chu\u1ea9n cho c\u00e1c \u00f4 \u0111\u01b0\u1ee3c \u0111\u1ebfm.<strong>\u00a0<\/strong><\/p>\n<p><strong>d. H\u00e0m COUNTIFS<\/strong><\/p>\n<p><strong>\u2013 C\u00fa ph\u00e1p: COUNTIFS(range1, criteria1, range2, criteria2, \u2026)<\/strong><\/p>\n<p><strong>\u2013 Ch\u1ee9c n\u0103ng:<\/strong>\u00a0H\u00e0m n\u00e0y d\u00f9ng \u0111\u1ec3 \u0111\u1ebfm t\u1ed5ng s\u1ed1 \u00f4 th\u1ecfa \u0111i\u1ec1u ki\u1ec7n y\u00eau c\u1ea7u<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 c\u00f4ng c\u1ee5 l\u00e0m vi\u1ec7c g\u1ea7n nh\u01b0 b\u1eaft bu\u1ed9c ph\u1ea3i c\u00f3 v\u1edbi k\u1ebf to\u00e1n v\u00e0 ki\u1ec3m to\u00e1n. \u0110\u00e2y c\u0169ng l\u00e0 c\u00f4ng c\u1ee5 \u0111\u1eafc l\u1ef1c gi\u00fap k\u1ebf to\u00e1n v\u00e0 ki\u1ec3m to\u00e1n vi\u00ean ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch nhanh ch\u00f3ng nh\u1ea5t. H\u1ecdc Vi\u1ec7n APT gi\u1edbi thi\u1ec7u 6 h\u00e0m th\u01b0\u1eddng d\u00f9ng nh\u1ea5t trong nghi\u1ec7p v\u1ee5 k\u1ebf [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":7638,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[508],"tags":[],"class_list":["post-7634","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office"],"_links":{"self":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/comments?post=7634"}],"version-history":[{"count":0,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/posts\/7634\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media\/7638"}],"wp:attachment":[{"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/media?parent=7634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/categories?post=7634"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tct.vn\/blog\/wp-json\/wp\/v2\/tags?post=7634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}