id: 18e1c14fb0aa44aba95025014ea7cd9b
parent_id: 
item_type: 1
item_id: 9a7f0b83ae2c4bf2aa8a1ddac0a76a26
item_updated_time: 1764345484917
title_diff: "[{\"diffs\":[[1,\"Excel 小教室 - 常用函數 IF、COUNTIF、COUNT、COUNTA 介紹 -\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":45}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>Excel 小教室 - 常用函數 IF、COUNTIF、COUNT、COUNTA 介紹 - 就是教不落</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"19915\\\"></a>\\\r\\\n<h1>Excel 小教室 - 常用函數 IF、COUNTIF、COUNT、COUNTA 介紹 - 就是教不落</h1>\\\r\\\n\\\r\\\n<div><span>\\\n  <div style=\\\"--en-clipped-content:article\\\">\\\n<div><br/></div><div style=\\\"font-size: 16px; display:block; min-width: 100%; position: relative;\\\"> <div><div style=\\\"color:rgb(85, 85, 85);font-weight:300;background:rgb(254, 254, 254);font-size:20px;font-family:&quot;noto sans tc&quot;, sans-serif;\\\"><div><div><div><div style=\\\"line-height:35px;\\\">\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">阿湯的讀者一定會發現最近的 Execl 教學文章比之前頻繁，因為很多有學習需求的朋友是老師或公務員，所以阿湯就將自己認為的必備功能趁著暑假一一專文介紹，今天要講的常用函數「IF、COUNTIF、COUNT、COUNTA」，沒接觸過往往會覺得很難，一大堆不同顏色的函數計算光看就頭大了根本不想懂，其實我們不需要一下子就學到那麼難，利用這些基礎的概念融會貫通，相信很快就能活用了。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"></p><div style=\\\"padding:0px;text-align:center;margin:15px auto;\\\">\\\n\\\n\\\n\\\n</div><p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"></p>\\\n<h3 style=\\\"border-bottom:3px solid rgb(51, 105, 168);font-size:25px;background:url(https://steachs.com/wp-content/themes/sc_combo/images/h3icon.png) 10px 0px no-repeat;line-height:50px;width:fit-content;margin:5px 0px;padding:0px 10px 0px 45px;\\\">IF</h3>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">IF 函數的結構是：IF（條件,結果1,結果2），概念很簡單，如果滿足前面的條件就會造成第一種結果，否則就是第二種，來看看範例。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">這個團購單假設大於 10 件免運費，就先點到運費那格，然後到公式頁面點「插入函數」，選擇使用「IF」函數就會出現輸入區，輸入條件「B9&gt;10,0,50」代表合計這欄如果大於 10 件運費 0，否則就要加 50 元。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/0a69d7863eaa4c639265981cd986240c\\\" type=\\\"image/png\\\" data-filename=\\\"01-24.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">確定後就計算出來了，第一格是 0 元，後面的就用滑鼠左鍵按住儲存格右下角＋號往後拖（就是複製的意思）。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/59422722220b415e91881bc01d8e858e\\\" type=\\\"image/png\\\" data-filename=\\\"02-21.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p><p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"></p><div style=\\\"padding:0px;text-align:center;margin:15px auto;\\\">\\\n\\\n\\\n\\\n</div><p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"></p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">完成後就會都用同樣的公式計算，如果表單很大，用這招就不用一個一個看到眼花囉。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/d62dded351754508876ff129b42d8818\\\" type=\\\"image/png\\\" data-filename=\\\"03-22.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<h3 style=\\\"border-bottom:3px solid rgb(51, 105, 168);font-size:25px;background:url(https://steachs.com/wp-content/themes/sc_combo/images/h3icon.png) 10px 0px no-repeat;line-height:50px;width:fit-content;margin:5px 0px;padding:0px 10px 0px 45px;\\\">COUNTIF</h3>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">COUNTIF 函數的結構是：COUNTIF=（範圍,條件），範圍就是要計算的儲存格位置，然後看是你要找到什麼項目，看看範例。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">這次要看四月份業績大於 10 萬的有多少人，一樣插入函數，在 Range（範圍）輸入「B6:I6」Criteria（條件）輸入「&gt;100000」，按確定。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/da35e1a917714255bd8366b9f0a82be9\\\" type=\\\"image/png\\\" data-filename=\\\"04-20.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">答案出來是 2 人，是不是很簡單。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/22f9046b539a4369ab84beb2be16226c\\\" type=\\\"image/png\\\" data-filename=\\\"05-20.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<h3 style=\\\"border-bottom:3px solid rgb(51, 105, 168);font-size:25px;background:url(https://steachs.com/wp-content/themes/sc_combo/images/h3icon.png) 10px 0px no-repeat;line-height:50px;width:fit-content;margin:5px 0px;padding:0px 10px 0px 45px;\\\">COUNT</h3>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">COUNT 函數的結構是：COUNT=（計算範圍），但範圍內一定要是「數字」才能被計算，如果是文字或是錯誤值就不會列入計算，請看範例。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">假設要算二月業績的達標人數，就在範圍輸入「C3:C10」點確定。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/24eb588aba94443bbb0355dfe98c9262\\\" type=\\\"image/png\\\" data-filename=\\\"06-17.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p><p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"></p><div style=\\\"padding:0px;text-align:center;margin:15px auto;\\\">\\\n\\\n<div style=\\\"margin:0px;padding:0px;\\\"></div>\\\n\\\n</div><p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"></p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">答案 7，只有數字被列入計算，「出國五天」是不會列入的。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/b6519b7fde0e4a15b587ba91d1cfefe1\\\" type=\\\"image/png\\\" data-filename=\\\"07-13.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<h3 style=\\\"border-bottom:3px solid rgb(51, 105, 168);font-size:25px;background:url(https://steachs.com/wp-content/themes/sc_combo/images/h3icon.png) 10px 0px no-repeat;line-height:50px;width:fit-content;margin:5px 0px;padding:0px 10px 0px 45px;\\\"><strong style=\\\"margin:0px;padding:0px;\\\">COUNTA</strong></h3>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">COUNTA 函數的結構是：COUNTA=（計算範圍），那不是跟上面 COUNT 一樣嗎？不是哦！COUNTA 是用在範圍內「有輸入資料」的格子，不是數字也會列入計算。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">這次來算要寄試用品的人數，輸入範圍「B5:T5」，按確定。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/09559eda750c46d0a6ec547b0e312595\\\" type=\\\"image/png\\\" data-filename=\\\"08-11.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">總共 13 人，因為是計算「非空白」的格數，所以只要有輸入就算一筆。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/2df352133e49446eb9904300434d6c56\\\" type=\\\"image/png\\\" data-filename=\\\"09-12.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">如果空格裡填的是「先不寄」也會被當成一個人，像下圖這樣，可以看到輸入的算式一模一樣，但真正的答案應該是 13 人才對，所以如果要使用這個函數，在製作表格的時候就要注意，免得算錯唷。</p>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\"><img src=\\\":/48e55bcedf614f64a40d11f6fd7a6ec5\\\" type=\\\"image/png\\\" data-filename=\\\"10-5.png\\\" height=\\\"419\\\" style=\\\"padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);display:block;margin:0px auto;margin-bottom:30px;\\\" width=\\\"800\\\"/></p>\\\n<blockquote style=\\\"background:none 0px 0px repeat scroll rgb(245, 245, 245);font-size:18px;margin:5px 0px;padding:10px 10px 0px;\\\"><p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">更多 Office 相關教學：<a href=\\\"https://steachs.com/archives/category/comab/office%E7%9B%B8%E9%97%9C%E6%95%99%E5%AD%B8\\\" rel=\\\"noopener noreferrer\\\" style=\\\"margin:0px;padding:0px;color:rgb(51, 105, 168);text-decoration:none;\\\" target=\\\"_blank\\\">請點我</a></p></blockquote>\\\n<p style=\\\"margin:0px;overflow-wrap:break-word;word-break:break-word;padding:0px 0px 10px;\\\">想看更多 Office 教學嗎？全新的影音頻道 Office 知識家上線囉，快點擊圖片前往訂閱。</p>\\t\\\n<a href=\\\"https://www.youtube.com/channel/UCLbfRwnOxbi2WpUZ9v98jsg\\\" style=\\\"margin:0px;padding:0px;color:rgb(51, 105, 168);text-decoration:none;\\\" target=\\\"_blank\\\" title=\\\"office教學\\\"><img src=\\\":/5f18051740984443a0c02e0c7b2e369a\\\" type=\\\"image/jpeg\\\" data-filename=\\\"officeyt.jpg\\\" height=\\\"34\\\" style=\\\"margin:0px;padding:0px;max-width:100%;height:auto;border:1px solid rgb(239, 239, 239);margin-bottom:30px;\\\" width=\\\"106\\\"/></a>\\\n<div style=\\\"padding:0px;margin:50px 0px;\\\">\\\n  <ul style=\\\"padding:0px;text-align:center;margin:10px 0px;\\\">\\\n    <li style=\\\"padding:0px;list-style:none;float:none;display:inline;font-size:18px;line-height:30px;margin:0px 0px 0px 21px;\\\">\\\n      <a href=\\\"https://www.facebook.com/sharer.php?u=https://steachs.com/archives/29395\\\" rel=\\\"nofollow noopener noreferrer\\\" style=\\\"margin:0px;padding:0px;color:rgb(51, 105, 168);text-decoration:none;\\\" target=\\\"_blank\\\" title=\\\"按一下以分享至 Facebook\\\"><i style=\\\"margin:0px;padding:0px;speak:none;font-style:normal;font-weight:400;font-variant:normal;text-transform:none;white-space:nowrap;overflow-wrap:normal;direction:ltr;line-height:1;font-feature-settings:&quot;liga&quot;;-webkit-font-smoothing:antialiased;font-family:IcoFont;\\\"><span style=\\\"font-style:normal;font-weight:400;font-variant:normal;text-transform:none;white-space:nowrap;direction:ltr;line-height:1;font-family:IcoFont;padding:15px;border-radius:30px;margin:0px 5px;color:rgb(66, 103, 190);font-size:20px;background:rgb(59, 89, 152);box-shadow:rgb(204, 204, 204) 1px 1px 2px;\\\"></span></i></a></li>\\\n    <li style=\\\"padding:0px;list-style:none;float:none;display:inline;font-size:18px;line-height:30px;margin:0px 0px 0px 21px;\\\">\\\n      <a href=\\\"https://twitter.com/intent/tweet?via=%E5%B0%B1%E6%98%AF%E6%95%99%E4%B8%8D%E8%90%BD&amp;text=Excel%20%E5%B0%8F%E6%95%99%E5%AE%A4%20%E2%80%93%20%E5%B8%B8%E7%94%A8%E5%87%BD%E6%95%B8%20IF%E3%80%81COUNTIF%E3%80%81COUNT%E3%80%81COUNTA%20%E4%BB%8B%E7%B4%B9&amp;url=https://steachs.com/archives/29395\\\" rel=\\\"nofollow noopener noreferrer\\\" style=\\\"margin:0px;padding:0px;color:rgb(51, 105, 168);text-decoration:none;\\\" target=\\\"_blank\\\" title=\\\"分享到 Twitter\\\"><i style=\\\"margin:0px;padding:0px;speak:none;font-style:normal;font-weight:400;font-variant:normal;text-transform:none;white-space:nowrap;overflow-wrap:normal;direction:ltr;line-height:1;font-feature-settings:&quot;liga&quot;;-webkit-font-smoothing:antialiased;font-family:IcoFont;\\\"><span style=\\\"font-style:normal;font-weight:400;font-variant:normal;text-transform:none;white-space:nowrap;direction:ltr;line-height:1;font-family:IcoFont;padding:15px;border-radius:30px;margin:0px 5px;color:rgb(255, 255, 255) !important;font-size:30px !important;background:rgb(29, 161, 242);\\\"></span></i></a></li>\\\n    <li style=\\\"padding:0px;list-style:none;float:none;display:inline;font-size:18px;line-height:30px;margin:0px 0px 0px 21px;\\\">\\\n      <a href=\\\"https://social-plugins.line.me/lineit/share?url=https://steachs.com/archives/29395\\\" rel=\\\"nofollow noopener noreferrer\\\" style=\\\"margin:0px;padding:0px;color:rgb(51, 105, 168);text-decoration:none;\\\" target=\\\"_blank\\\" title=\\\"分享到 LINE\\\"><i style=\\\"margin:0px;padding:0px;speak:none;font-style:normal;font-weight:400;font-variant:normal;text-transform:none;white-space:nowrap;overflow-wrap:normal;direction:ltr;line-height:1;font-feature-settings:&quot;liga&quot;;-webkit-font-smoothing:antialiased;font-family:IcoFont;\\\"><span style=\\\"font-style:normal;font-weight:400;font-variant:normal;text-transform:none;white-space:nowrap;direction:ltr;line-height:1;font-family:IcoFont;padding:15px;border-radius:30px;margin:0px 5px;color:rgb(255, 255, 255) !important;font-size:30px !important;background:rgb(0, 195, 0);\\\"></span></i></a></li>      \\\n    </ul>\\\n</div>\\\n</div></div></div></div></div></div></div>\\\n</div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":12992}]"
metadata_diff: {"new":{"id":"9a7f0b83ae2c4bf2aa8a1ddac0a76a26","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345718505,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:12:40.223Z
created_time: 2025-11-28T16:12:40.223Z
type_: 13