{"id":32369,"date":"2023-05-24T09:00:00","date_gmt":"2023-05-24T02:00:00","guid":{"rendered":"https:\/\/adsplus.vn\/blog\/?p=32369"},"modified":"2023-04-28T11:47:40","modified_gmt":"2023-04-28T04:47:40","slug":"tong-hop-cac-ham-quan-trong-trong-google-sheets","status":"publish","type":"post","link":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets","title":{"rendered":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets"},"content":{"rendered":"\n<p>Google Sheets l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n. C\u00f4ng c\u1ee5 n\u00e0y cung c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng nhi\u1ec1u ti\u1ec7n \u00edch \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c. N\u1ebfu ng\u01b0\u1eddi dung kh\u00f4ng t\u00ecm hi\u1ec3u k\u1ef9 v\u1ec1 c\u00e1c h\u00e0m c\u00f3 trong c\u00f4ng c\u1ee5 n\u00e0y th\u00ec s\u1ebd kh\u00f3 t\u1eadn d\u1ee5ng h\u1ebft \u01b0u \u0111i\u1ec3m c\u1ee7a n\u00f3. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m c\u1ee7a Google Sheets h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng l\u00e0m vi\u1ec7t hi\u1ec7u qu\u1ea3.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"722\" height=\"401\" src=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets.jpg\" alt=\"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets\" class=\"wp-image-32380\" srcset=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets.jpg 722w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets-300x167.jpg 300w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets-218x121.jpg 218w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets-436x242.jpg 436w, https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets-720x401.jpg 720w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Xem th\u00eam:<\/strong><\/h4>\n\n\n\n<ul><li><a href=\"https:\/\/adsplus.vn\/blog\/nhung-dieu-can-biet-khi-chay-quang-cao-ung-dung-hoc\/\">Nh\u1eefng \u0111i\u1ec1u c\u1ea7n bi\u1ebft khi ch\u1ea1y qu\u1ea3ng c\u00e1o \u1ee9ng d\u1ee5ng h\u1ecdc<\/a><\/li><li><a href=\"https:\/\/adsplus.vn\/blog\/lam-the-nao-de-su-dung-chat-gpt-trong-microsoft-excel\/\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng Chat GPT trong Microsoft Excel?<\/a><\/li><li><a href=\"https:\/\/adsplus.vn\/blog\/google-bard-la-gi-tim-hieu-uu-diem-va-nhuoc-diem\/\">Google Bard l\u00e0 g\u00ec? T\u00ecm hi\u1ec3u \u01b0u v\u00e0 nh\u01b0\u1ee3c \u0111i\u1ec3m<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>H\u00e0m Sum<\/strong> <strong>trong Google Sheet<\/strong><\/h2>\n\n\n\n<p>H\u00e0m Sum trong Google Sheet \u0111\u01b0\u1ee3c d\u00f9ng v\u1ec1 t\u1ed5ng h\u1ee3p c\u00e1c gi\u00e1 tr\u1ecb trong c\u00f9ng m\u1ed9t ph\u1ea1m v\u1ecb. \u0110\u00e2y \u0111\u01b0\u1ee3c xem l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn c\u1ee7a Google Sheet. H\u00e0m Sum \u0111\u01b0\u1ee3c t\u00ednh theo c\u00f4ng th\u1ee9c sau:<\/p>\n\n\n\n<p><strong>&nbsp;\u201c=Sum([gi\u00e1 tr\u1ecb 1];[gi\u00e1 tr\u1ecb 2];&#8230;)\u201d<\/strong><\/p>\n\n\n\n<p>V\u1edbi gi\u00e1 tr\u1ecb 1 l\u00e0 s\u1ed1 \u0111\u1ea7u ti\u00ean trong ph\u1ea1m vi m\u00e0 ng\u01b0\u1eddi mu\u1ed1n t\u00ednh to\u00e0n. Gi\u00e1 tr\u1ecb 2 l\u00e0 nh\u1eefng s\u1ed1 \u1edf nh\u1eefng v\u1ecb tr\u00ed kh\u00e1c nhau trong c\u00f9ng ph\u1ea1m vi v\u1edbi gi\u00e1 tr\u1ecb 1. V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng t\u1eeb B1 \u0111\u1ebfn B5 th\u00ec s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c \u201c=Sum(B1;B5)\u201d<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>H\u00e0m Max v\u00e0 h\u00e0m Min<\/strong><\/h2>\n\n\n\n<p>Hai lo\u1ea1i h\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm ra \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong ph\u1ea1m vi t\u1eeb B1 \u0111\u1ebfn B5, s\u1ebd c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau <strong>\u201c=Max(B1:B5)\u201d<\/strong>. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady, n\u1ebfu b\u1ea1n mu\u1ed1n t\u00ecm ra gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t t\u1eeb B1 \u0111\u1ebfn B5. C\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c nh\u1eadp<strong> \u201c=Min(B1:B5)\u201d<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>H\u00e0m If<\/strong><\/h2>\n\n\n\n<p>H\u00e0m If&nbsp; l\u00e0 m\u1ed9t trong c\u00e1c h\u00e0m quan tr\u1ecdng c\u1ee7a Google Sheet. H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u01b0ng l\u1ea1i nhi\u1ec1u l\u1ea7n l\u00e0m nhi\u1ec1u ng\u01b0\u1eddi b\u1ed1i r\u1ed1i v\u1edbi c\u00e1ch d\u00f9ng. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 gi\u00fap ng\u01b0\u1eddi t\u00ecm ra \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 \u0111\u00fang k\u1ebft qu\u1ea3 m\u00e0 h\u1ecd mu\u1ed1n. V\u1edbi c\u00f4ng th\u1ee9c:<\/p>\n\n\n\n<p><strong>\u201c=IF(bi\u1ec3u_th\u1ee9c_logic; gi\u00e1_tr\u1ecb_n\u1ebfu_\u0111\u00fang; gi\u00e1_tr\u1ecb_n\u1ebfu_sai)<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3, bi\u1ec3u th\u1ee9c logic l\u00e0 bi\u1ec3u th\u1ee9c \u0111\u01b0\u1ee3c so s\u00e1nh. Gi\u00e1 tr\u1ecb \u0111\u00fang l\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 h\u00e0m tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb \u0111\u00fang v\u1edbi y\u00eau c\u1ea7u khi bi\u1ec3u th\u1ee9c logic \u0111\u00fang. Ng\u01b0\u1ee3c l\u1ea1i, n\u1ebfu bi\u1ec3u th\u1ee9c logic sai th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb kh\u00e1c.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>H\u00e0m Google Translate<\/strong><\/h2>\n\n\n\n<p>\u0110\u00e2y l\u00e0 h\u00e0m d\u00f9ng \u0111\u1ec3 d\u1ecbch v\u0103n b\u1ea3n. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 d\u1ecbch v\u0103n b\u1ea3n t\u1eeb ng\u00f4n&nbsp;ng\u1eef n\u00e0y sang m\u1ed9t ng\u00f4n ng\u1eef kh\u00e1c. H\u00e0m \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng v\u1edbi c\u00f4ng th\u1ee9c:<\/p>\n\n\n\n<p><strong>\u201c=GOOGLETRANSLATE(v\u0103n b\u1ea3n; [ng\u00f4n_ng\u1eef_ngu\u1ed3n]; [ng\u00f4n_ng\u1eef_\u0111\u00edch])\u201d<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3, v\u0103n b\u1ea3n l\u00e0 n\u1ed9i dung m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n d\u1ecbch. Ng\u00f4n ng\u1eef ngu\u1ed3n l\u00e0 ng\u00f4n ng\u1eef g\u1ed1c c\u1ee7a v\u0103n b\u1ea3n, m\u00e3 n\u00e0y s\u1ebd c\u00f3 hai ch\u1eef c\u00e1i. Ng\u00f4n ng\u1eef \u0111\u00edch c\u0169ng ch\u1eef d\u1ee5ng m\u00e3 hai ch\u1eef c\u00e1i v\u1edbi ng\u00f4n ng\u1eef m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n d\u1ecbch.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>H\u00e0m VLookup v\u00e0 HLookup<\/strong><\/h2>\n\n\n\n<p>Trong c\u00e1c h\u00e0m c\u1ee7a Google Sheets th\u00ec VLookup v\u00e0 HLookup l\u00e0 hai h\u00e0m d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm trong b\u1ea3ng d\u1eef li\u1ec7u theo h\u00e0ng d\u1ecdc v\u00e0 h\u00e0ng ngang. Hai h\u00e0m n\u00e0y th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 d\u00f2 t\u00ecm t\u00ean s\u1ea3n ph\u1ea9m, s\u1ed1 l\u01b0\u1ee3ng, m\u00e3 v\u1ea1ch,&#8230; C\u00f4ng th\u1ee9c c\u1ee7a VLookup v\u00e0 HLookup:<\/p>\n\n\n\n<p><strong>\u201c=VLOOKUP(kh\u00f3a_t\u00ecm_ki\u1ebfm; d\u1ea3i \u00f4; ch\u1ec9 m\u1ee5c; [\u0111\u01b0\u1ee3c_s\u1eafp_x\u1ebfp])\u201d<\/strong><\/p>\n\n\n\n<p><strong>\u201c=HLOOKUP(kh\u00f3a_t\u00ecm_ki\u1ebfm; d\u1ea3i \u00f4; ch\u1ec9 m\u1ee5c; [\u0111\u01b0\u1ee3c_s\u1eafp_x\u1ebfp])\u201d<\/strong><\/p>\n\n\n\n<p>Trong \u0111\u00f3, kh\u00f3a_t\u00ecm_ki\u1ebfm l\u00e0 nh\u1eefng gi\u00e1 tr\u1ecb c\u1ea7n \u0111\u1ec3 d\u00f2 t\u00ecm. D\u00e0i \u00f4 l\u00e0 b\u1ea3ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb c\u1ea7n d\u00f2 t\u00ecm. Ch\u1ec9 m\u1ee5c ch\u1ec9 v\u1ecb tr\u00ed c\u1ee7a h\u00e0ng hay c\u1ed9t m\u00e0 ng\u01b0\u1eddi d\u00f9ng mu\u1ed1n d\u00f2 t\u00ecm. \u0110\u01b0\u1ee3c_s\u1eafp_x\u1ebfp l\u00e0 ph\u1ea1m v\u1ecb ch\u1ee9a d\u1eef li\u1ec7u mu\u1ed1n t\u00ecm ki\u1ebfm.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong><a rel=\"noreferrer noopener\" href=\"https:\/\/adsplus.vn\/\" target=\"_blank\">Adsplus.vn<\/a><\/strong><\/h4>\n\n\n\n<p><em>C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 xem b\u00e0i vi\u1ebft <\/em>n\u00e0y<em>. H\u00e3y c\u1eadp nh\u1eadt th\u00eam c\u00e1c b\u00e0i vi\u1ebft t\u1eeb Adsplus \u0111\u1ec3 bi\u1ebft th\u00eam nh\u1eefng th\u00f4ng tin m\u1edbi nh\u1ea5t v\u1ec1 Google.<\/em> V<em>\u00e0 c\u00e1c Tips ch\u1ea1y qu\u1ea3ng c\u00e1o hi\u1ec7u qu\u1ea3.<\/em><\/p>\n\n\n\n<ul><li><span class=\"has-inline-color has-vivid-red-color\">Tham kh\u1ea3o c\u00e1c kh\u00f3a h\u1ecdc Google Ads, Facebook Ads t\u1ea1i <strong><a href=\"https:\/\/guru.edu.vn\/\">guru.edu.vn<\/a><\/strong><\/span><\/li><li><span class=\"has-inline-color has-vivid-red-color\">Tham kh\u1ea3o c\u00e1c g\u00f3i setup t\u00e0i kho\u1ea3n qu\u1ea3ng c\u00e1o Google Ads, Facebook Ads t\u1ea1i <strong><a rel=\"nofollow noreferrer noopener\" href=\"https:\/\/hubs.la\/H0BrYSB0\" target=\"_blank\">1ad.vn<\/a><\/strong><\/span><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 h\u1ed7 tr\u1ee3 ng\u01b0\u1eddi d\u00f9ng trong vi\u1ec7c qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n. C\u00f4ng c\u1ee5 n\u00e0y cung c\u1ea5p cho ng\u01b0\u1eddi d\u00f9ng nhi\u1ec1u ti\u1ec7n \u00edch \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c. N\u1ebfu ng\u01b0\u1eddi dung kh\u00f4ng t\u00ecm hi\u1ec3u k\u1ef9 v\u1ec1 c\u00e1c h\u00e0m c\u00f3 trong c\u00f4ng c\u1ee5 n\u00e0y th\u00ec s\u1ebd kh\u00f3 t\u1eadn d\u1ee5ng [&hellip;]<\/p>\n","protected":false},"author":72,"featured_media":32380,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1154],"tags":[392,1049],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets | Adsplus.vn<\/title>\n<meta name=\"description\" content=\"C\u00e1c h\u00e0m tr\u00ean Google Sheets l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng khi l\u00e0m vi\u1ec7c.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets | Adsplus.vn\" \/>\n<meta property=\"og:description\" content=\"C\u00e1c h\u00e0m tr\u00ean Google Sheets l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng khi l\u00e0m vi\u1ec7c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets\" \/>\n<meta property=\"og:site_name\" content=\"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/AdsplusVietnam\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-24T02:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-28T04:47:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"722\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dung\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dung\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets\",\"url\":\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets\",\"name\":\"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets | Adsplus.vn\",\"isPartOf\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/#website\"},\"datePublished\":\"2023-05-24T02:00:00+00:00\",\"dateModified\":\"2023-04-28T04:47:40+00:00\",\"author\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854\"},\"description\":\"C\u00e1c h\u00e0m tr\u00ean Google Sheets l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng khi l\u00e0m vi\u1ec7c.\",\"breadcrumb\":{\"@id\":\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/adsplus.vn\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#website\",\"url\":\"https:\/\/adsplus.vn\/blog\/\",\"name\":\"Adsplus Blog\",\"description\":\"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/adsplus.vn\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854\",\"name\":\"Dung\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g\",\"caption\":\"Dung\"},\"url\":\"https:\/\/adsplus.vn\/blog\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets | Adsplus.vn","description":"C\u00e1c h\u00e0m tr\u00ean Google Sheets l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng khi l\u00e0m vi\u1ec7c.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets | Adsplus.vn","og_description":"C\u00e1c h\u00e0m tr\u00ean Google Sheets l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng khi l\u00e0m vi\u1ec7c.","og_url":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets","og_site_name":"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online","article_publisher":"https:\/\/www.facebook.com\/AdsplusVietnam\/","article_published_time":"2023-05-24T02:00:00+00:00","article_modified_time":"2023-04-28T04:47:40+00:00","og_image":[{"width":722,"height":401,"url":"https:\/\/adsplus.vn\/blog\/wp-content\/uploads\/2023\/04\/tong-hop-cac-ham-quan-trong-trong-google-sheets.jpg","type":"image\/jpeg"}],"author":"Dung","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dung","Est. reading time":"5 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets","url":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets","name":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets | Adsplus.vn","isPartOf":{"@id":"https:\/\/adsplus.vn\/blog\/#website"},"datePublished":"2023-05-24T02:00:00+00:00","dateModified":"2023-04-28T04:47:40+00:00","author":{"@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854"},"description":"C\u00e1c h\u00e0m tr\u00ean Google Sheets l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 gi\u00fap ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 qu\u1ea3n l\u00fd v\u00e0 t\u00ednh to\u00e1n nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng khi l\u00e0m vi\u1ec7c.","breadcrumb":{"@id":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/adsplus.vn\/blog\/tong-hop-cac-ham-quan-trong-trong-google-sheets#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/adsplus.vn\/blog\/"},{"@type":"ListItem","position":2,"name":"T\u1ed5ng h\u1ee3p c\u00e1c h\u00e0m quan tr\u1ecdng trong Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/adsplus.vn\/blog\/#website","url":"https:\/\/adsplus.vn\/blog\/","name":"Adsplus Blog","description":"K\u00eanh chia s\u1ebb ki\u1ebfn th\u1ee9c marketing online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adsplus.vn\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/7f9c890528019a19c8a6949b8d451854","name":"Dung","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/adsplus.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17ad2c01642b3b8af86d6623adc23f17?s=96&d=mm&r=g","caption":"Dung"},"url":"https:\/\/adsplus.vn\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts\/32369"}],"collection":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/users\/72"}],"replies":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/comments?post=32369"}],"version-history":[{"count":0,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/posts\/32369\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/media\/32380"}],"wp:attachment":[{"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/media?parent=32369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/categories?post=32369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adsplus.vn\/blog\/wp-json\/wp\/v2\/tags?post=32369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}