{"id":68991,"date":"2024-09-11T07:55:15","date_gmt":"2024-09-11T07:55:15","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=68991"},"modified":"2024-09-11T07:55:15","modified_gmt":"2024-09-11T07:55:15","slug":"%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%ad%d8%b3%d8%a7%d8%a8-%d8%a7%d9%84%d9%82%d9%8a%d9%85-%d8%a7%d9%84%d9%81%d8%b1%d9%8a%d8%af%d8%a9-%d9%81%d9%8a-microsoft-excel","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%ad%d8%b3%d8%a7%d8%a8-%d8%a7%d9%84%d9%82%d9%8a%d9%85-%d8%a7%d9%84%d9%81%d8%b1%d9%8a%d8%af%d8%a9-%d9%81%d9%8a-microsoft-excel\/","title":{"rendered":"\u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%ad%d8%b3%d8%a7%d8%a8-%d8%a7%d9%84%d9%82%d9%8a%d9%85-%d8%a7%d9%84%d9%81%d8%b1%d9%8a%d8%af%d8%a9-%d9%81%d9%8a-microsoft-excel\/#%D8%B1%D9%88%D8%A7%D8%A8%D8%B7_%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9\" title=\"\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629\">\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%ad%d8%b3%d8%a7%d8%a8-%d8%a7%d9%84%d9%82%d9%8a%d9%85-%d8%a7%d9%84%d9%81%d8%b1%d9%8a%d8%af%d8%a9-%d9%81%d9%8a-microsoft-excel\/#%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D9%85_%D8%A7%D9%84%D8%AF%D8%A7%D9%84%D8%AA%D9%8A%D9%86_COUNTA_%D9%88UNIQUE\" title=\"\u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 COUNTA \u0648UNIQUE\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 COUNTA \u0648UNIQUE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%ad%d8%b3%d8%a7%d8%a8-%d8%a7%d9%84%d9%82%d9%8a%d9%85-%d8%a7%d9%84%d9%81%d8%b1%d9%8a%d8%af%d8%a9-%d9%81%d9%8a-microsoft-excel\/#%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D9%85_%D8%A7%D9%84%D8%AF%D8%A7%D9%84%D8%AA%D9%8A%D9%86_SUM_%D9%88COUNTIF\" title=\"\u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 SUM \u0648COUNTIF\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 SUM \u0648COUNTIF<\/a><\/li><\/ul><\/nav><\/div>\n<div>\n<div class=\"w-table-content\">\n<h3 class=\"title icon i-flash\"><span class=\"ez-toc-section\" id=\"%D8%B1%D9%88%D8%A7%D8%A8%D8%B7_%D8%B3%D8%B1%D9%8A%D8%B9%D8%A9\"><\/span>\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<div class=\"table-content\">\n<div class=\"w-table-content-list\">\n<ul class=\"table-content-list\">\n<li class=\"table-content-element icon\">\n<div class=\"table-content-link\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"#use-the-counta-and-unique-functions\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 COUNTA \u0648UNIQUE<\/a> <\/div>\n<\/li>\n<\/ul>\n<ul class=\"table-content-list\">\n<li class=\"table-content-element icon\">\n<div class=\"table-content-link\"><a rel=\"nofollow noopener\" target=\"_blank\" href=\"#use-the-sum-and-countif-functions\">\u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 SUM \u0648COUNTIF<\/a> <\/div>\n<\/li>\n<\/ul><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 COUNT \u0648\u0627\u0644\u0627\u062e\u062a\u0644\u0627\u0641\u0627\u062a \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0647\u0627 \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0623\u0631\u0642\u0627\u0645. \u0648\u0644\u0643\u0646 \u0645\u0627\u0630\u0627 \u0644\u0648 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u0645\u064a\u0632\u0629 \u0641\u0642\u0637 \u0641\u064a \u0646\u0637\u0627\u0642 \u062e\u0644\u0627\u064a\u0627\u061f \u0633\u0646\u0639\u0631\u0636 \u0644\u0643 \u0637\u0631\u064a\u0642\u062a\u064a\u0646 \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a Excel.<\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":0,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":0,\"nbrPlacementsScanned\":0,\"ruleCount\":200,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":215} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":0,\"ruleCount\":200,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":200,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><br \/>\n<!-- No winning ad found for zone: below first paragraph! --><br \/>\n<!-- No winning ad found for zone: mid intro! --><\/p>\n<p>\u062a\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0637\u0631\u064a\u0642\u062a\u0627\u0646 \u0627\u0644\u0644\u062a\u0627\u0646 \u0633\u0646\u0634\u0631\u062d\u0647\u0645\u0627 \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0648\u0627\u0644\u0627\u062e\u062a\u0644\u0627\u0641\u0627\u062a \u0641\u064a \u062f\u0627\u0644\u0629 COUNT. \u0648\u0644\u0623\u0646 \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0644\u062f\u064a\u0643 \u0642\u062f \u064a\u062a\u0636\u0645\u0646 \u062e\u0644\u0627\u064a\u0627 \u0641\u0627\u0631\u063a\u0629\u060c \u0641\u0625\u0646\u0646\u0627 \u0646\u062f\u0631\u062c \u0635\u064a\u063a\u064b\u0627 \u0628\u062f\u064a\u0644\u0629 \u0644\u0645\u0631\u0627\u0639\u0627\u0629 \u0630\u0644\u0643.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":216} --><\/p>\n<p><span class=\"related-single\">\u0630\u0627\u062a \u0635\u0644\u0629: \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062f\u0627\u0644\u0629 COUNT \u0641\u064a Microsoft Excel<\/span><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":273} --><br \/>\n<!-- No winning ad found for zone: native in content! --><\/p>\n<h2 id=\"use-the-counta-and-unique-functions\"><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D9%85_%D8%A7%D9%84%D8%AF%D8%A7%D9%84%D8%AA%D9%8A%D9%86_COUNTA_%D9%88UNIQUE\"><\/span>  \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 COUNTA \u0648UNIQUE <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0647\u0630\u0647 \u0627\u0644\u0637\u0631\u064a\u0642\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0645\u062e\u0635\u0635\u0629 \u0644\u0623\u0648\u0644\u0626\u0643 \u0627\u0644\u0630\u064a\u0646 \u064a\u0633\u062a\u062e\u062f\u0645\u0648\u0646 Excel \u0644\u0640 Microsoft 365 \u0623\u0648 Excel \u0644\u0644\u0648\u064a\u0628 \u0623\u0648 Excel 2021 \u0623\u0648 Excel \u0644\u0623\u062c\u0647\u0632\u0629 iPhone \u0623\u0648 iPad \u0623\u0648 \u0627\u0644\u0647\u0648\u0627\u062a\u0641 \u0623\u0648 \u0627\u0644\u0623\u062c\u0647\u0632\u0629 \u0627\u0644\u0644\u0648\u062d\u064a\u0629 \u0627\u0644\u062a\u064a \u062a\u0639\u0645\u0644 \u0628\u0646\u0638\u0627\u0645 Android. \u0648\u0630\u0644\u0643 \u0644\u0623\u0646 \u0648\u0638\u064a\u0641\u0629 UNIQUE \u0645\u062a\u0648\u0641\u0631\u0629 \u0641\u0642\u0637 \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0625\u0635\u062f\u0627\u0631\u0627\u062a \u0648\u0627\u0644\u0625\u0635\u062f\u0627\u0631\u0627\u062a \u0627\u0644\u0623\u062d\u062f\u062b \u0645\u0646 Excel.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":516} --><\/p>\n<p>\u062a\u0648\u0641\u0631 \u0627\u0644\u062f\u0627\u0644\u0629 UNIQUE \u062c\u0645\u064a\u0639 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u0645\u064a\u0632\u0629 \u0641\u064a \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627. \u0648\u0644\u0623\u0646\u0643 \u0644\u0627 \u062a\u0631\u064a\u062f \u0625\u062f\u0631\u0627\u062c \u0647\u0630\u0647 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629\u060c \u0628\u0644 \u0639\u062f\u0647\u0627 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0630\u0644\u0643\u060c \u0641\u0633\u0648\u0641 \u062a\u0636\u064a\u0641 \u0627\u0644\u062f\u0627\u0644\u0629 COUNTA. \u062a\u062d\u0633\u0628 \u0627\u0644\u062f\u0627\u0644\u0629 COUNTA \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u063a\u064a\u0631 \u0627\u0644\u0641\u0627\u0631\u063a\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":740} --><\/p>\n<p>\u0644\u0625\u062f\u0631\u0627\u062c \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0645\u0646 A2 \u0625\u0644\u0649 A5\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":826} --><\/p>\n<pre>=UNIQUE(A2:A5)<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":840} --><\/p>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0623\u0646 \u062a\u0631\u0649 \u0647\u0646\u0627 \u0623\u0646 \u0644\u062f\u064a\u0646\u0627 \u062b\u0644\u0627\u062b \u0642\u064a\u0645 \u0645\u0645\u064a\u0632\u0629 \u0645\u062f\u0631\u062c\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":894} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":894,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":6,\"nextBlockCount\":240,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":1134} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":1,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":1,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":1,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"480\" height=\"220\" loading=\"lazy\" alt=\"\u0648\u0638\u064a\u0641\u0629 \u0641\u0631\u064a\u062f\u0629 \u0641\u064a Excel\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/\u0643\u064a\u0641\u064a\u0629-\u062d\u0633\u0627\u0628-\u0627\u0644\u0642\u064a\u0645-\u0627\u0644\u0641\u0631\u064a\u062f\u0629-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AD%D8%B3%D8%A7%D8%A8-%D8%A7%D9%84%D9%82%D9%8A%D9%85-%D8%A7%D9%84%D9%81%D8%B1%D9%8A%D8%AF%D8%A9-%D9%81%D9%8A-Microsoft-Excel.png?resize=480%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":234} --><\/p>\n<p>\u0644\u062d\u0633\u0627\u0628 \u062a\u0644\u0643 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0625\u062f\u0631\u0627\u062c\u0647\u0627\u060c \u0623\u0636\u0641 \u0627\u0644\u062f\u0627\u0644\u0629 COUNTA \u0625\u0644\u0649 \u0628\u062f\u0627\u064a\u0629 \u0627\u0644\u0635\u064a\u063a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":348} --><\/p>\n<pre>=COUNTA(UNIQUE(A2:A5))<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":370} --><\/p>\n<p>\u0627\u0644\u0622\u0646 \u0623\u0635\u0628\u062d \u0644\u062f\u064a\u0643 \u0627\u0644\u0639\u062f\u062f \u0627\u0644\u062e\u0627\u0635 \u0628\u062a\u0644\u0643 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0648\u0647\u0648 3.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":428} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"540\" height=\"220\" loading=\"lazy\" alt=\"COUNTA \u0645\u0639 UNIQUE \u0641\u064a Excel\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041312_658_\u0643\u064a\u0641\u064a\u0629-\u062d\u0633\u0627\u0628-\u0627\u0644\u0642\u064a\u0645-\u0627\u0644\u0641\u0631\u064a\u062f\u0629-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041312_658_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AD%D8%B3%D8%A7%D8%A8-%D8%A7%D9%84%D9%82%D9%8A%D9%85-%D8%A7%D9%84%D9%81%D8%B1%D9%8A%D8%AF%D8%A9-%D9%81%D9%8A-Microsoft-Excel.png?resize=540%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":668} --><\/p>\n<p>\u0625\u0630\u0627 \u0643\u0627\u0646 \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0630\u064a \u062a\u0631\u064a\u062f \u062d\u0633\u0627\u0628\u0647 \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0641\u0631\u0627\u063a\u0627\u062a\u060c \u0641\u0633\u064a\u062a\u0645 \u062a\u0636\u0645\u064a\u0646\u0647\u0627 \u0643\u0642\u064a\u0645 \u0641\u0631\u064a\u062f\u0629 \u0642\u062f \u062a\u0633\u0628\u0628 \u0645\u0634\u0643\u0644\u0629. \u0644\u0627\u0633\u062a\u0628\u0639\u0627\u062f \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u0641\u0627\u0631\u063a\u0629 \u0641\u064a \u0646\u0637\u0627\u0642\u0643\u060c \u064a\u0645\u0643\u0646\u0643 \u0625\u0636\u0627\u0641\u0629 \u0627\u0644\u062f\u0627\u0644\u0629 FILTER \u0625\u0644\u0649 \u0627\u0644\u0635\u064a\u063a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":873} --><\/p>\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_15\">\n<div class=\"custom_block-content note\">\n<p>\u062a\u062a\u0648\u0641\u0631 \u0648\u0638\u064a\u0641\u0629 FILTER \u0641\u0642\u0637 \u0641\u064a \u0625\u0635\u062f\u0627\u0631\u0627\u062a Excel \u0627\u0644\u0645\u0630\u0643\u0648\u0631\u0629<br \/>\n<a rel=\"nofollow noopener\" target=\"_blank\" href=\"#moka_anchor_Versions\">\u0641\u0648\u0642<\/a><br \/>\n.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":2,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":2,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":1113} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":2,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":0} --><\/p>\n<pre>=COUNTA(UNIQUE(FILTER(A2:A5,A2:A5&lt;&gt;\"\")))<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":56} --><\/p>\n<p>\u062f\u0639\u0648\u0646\u0627 \u0646\u0642\u0648\u0645 \u0628\u062a\u062d\u0644\u064a\u0644 \u062c\u0632\u0621 FILTER \u0645\u0646 \u0627\u0644\u0635\u064a\u063a\u0629. <code>A2:A5,A2:A5<\/code> \u064a\u0645\u062b\u0644 \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0648\u0627\u0644\u0645\u0639\u0627\u064a\u064a\u0631 \u0627\u0644\u062a\u064a \u064a\u062c\u0628 \u062a\u0635\u0641\u064a\u062a\u0647\u0627 \u0648\u0627\u0644\u062a\u064a \u0647\u064a \u0646\u0641\u0633\u0647\u0627\u060c <code>&lt;&gt;<\/code> \u064a\u0645\u062b\u0644 \u0644\u0627 \u064a\u0633\u0627\u0648\u064a\u060c \u0648 <code>\"\"<\/code> \u064a\u0645\u062b\u0644 \u0627\u0644\u0641\u0631\u0627\u063a.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":265} --><\/p>\n<p>\u0643\u0645\u0627 \u062a\u0631\u0649 \u0641\u064a \u0644\u0642\u0637\u0629 \u0627\u0644\u0634\u0627\u0634\u0629 \u0623\u062f\u0646\u0627\u0647\u060c \u0644\u0627 \u064a\u062a\u0645 \u0627\u062d\u062a\u0633\u0627\u0628 \u0627\u0644\u062e\u0644\u064a\u0629 \u0627\u0644\u0641\u0627\u0631\u063a\u0629 \u0641\u064a \u0627\u0644\u0645\u0635\u0641\u0648\u0641\u0629 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0646\u0627 \u0643\u0642\u064a\u0645\u0629 \u0641\u0631\u064a\u062f\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":366} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"650\" height=\"210\" loading=\"lazy\" alt=\"\u0648\u0638\u0627\u0626\u0641 COUNTA \u0648UNIQUE \u0648FILTER\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041312_19_\u0643\u064a\u0641\u064a\u0629-\u062d\u0633\u0627\u0628-\u0627\u0644\u0642\u064a\u0645-\u0627\u0644\u0641\u0631\u064a\u062f\u0629-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041312_19_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AD%D8%B3%D8%A7%D8%A8-%D8%A7%D9%84%D9%82%D9%8A%D9%85-%D8%A7%D9%84%D9%81%D8%B1%D9%8A%D8%AF%D8%A9-%D9%81%D9%8A-Microsoft-Excel.png?resize=650%2C210&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":606} --><\/p>\n<p><span class=\"related-single\">\u0630\u0627\u062a \u0635\u0644\u0629: \u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0639\u062f\u062f \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0641\u064a Microsoft Excel<\/span><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":652} --><\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":652} --><\/p>\n<h2 id=\"use-the-sum-and-countif-functions\"><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B3%D8%AA%D8%AE%D8%AF%D9%85_%D8%A7%D9%84%D8%AF%D8%A7%D9%84%D8%AA%D9%8A%D9%86_SUM_%D9%88COUNTIF\"><\/span>  \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 SUM \u0648COUNTIF <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 \u0625\u0635\u062f\u0627\u0631 Excel \u062d\u064a\u062b \u0644\u0627 \u062a\u062a\u0648\u0641\u0631 \u0627\u0644\u062f\u0627\u0644\u062a\u0627\u0646 UNIQUE \u0648FILTER\u060c \u0641\u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 SUM \u0648COUNTIF \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0630\u0644\u0643.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":782} --><\/p>\n<section class=\"emaki-custom-block emaki-custom-note\">\n<div class=\"emaki-custom note\" id=\"custom_block_23\">\n<div class=\"custom_block-content note\">\n<p>\u064a\u0645\u0643\u0646\u0643 \u0623\u064a\u0636\u064b\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0646\u0641\u0633 \u0627\u0644\u0635\u064a\u063a \u0623\u062f\u0646\u0627\u0647 \u0648\u0627\u0633\u062a\u0628\u062f\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 SUM \u0628\u0640 SUMPRODUCT.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":3,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":3,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":1022} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":3,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} --><\/section>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":0} --><\/p>\n<p>\u062a\u0642\u0648\u0645 \u062f\u0627\u0644\u0629 SUM \u0628\u0625\u0636\u0627\u0641\u0629 \u0627\u0644\u0623\u0631\u0642\u0627\u0645 \u0648\u062a\u0642\u0648\u0645 \u062f\u0627\u0644\u0629 COUNTIF \u0628\u062d\u0633\u0627\u0628 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0623\u0631\u0642\u0627\u0645 \u062a\u0644\u0628\u064a \u0645\u0639\u0627\u064a\u064a\u0631 \u0645\u0639\u064a\u0646\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":121} --><\/p>\n<p>\u0644\u0644\u0639\u062b\u0648\u0631 \u0639\u0644\u0649 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 A2 \u0625\u0644\u0649 A5\u060c \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":206} --><\/p>\n<pre>=SUM(1\/COUNTIF(A2:A5,A2:A5))<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":234} --><\/p>\n<p>\u0644\u062a\u0641\u0643\u064a\u0643 \u0647\u0630\u0647 \u0627\u0644\u0635\u064a\u063a\u0629\u060c <code>COUNTIF<\/code> \u062a\u062d\u0633\u0628 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0623\u0631\u0642\u0627\u0645 \u0641\u064a \u0646\u0637\u0627\u0642\u0646\u0627 \u0648\u062a\u0633\u062a\u062e\u062f\u0645 \u0646\u0641\u0633 \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0643\u0645\u0639\u064a\u0627\u0631. \u062b\u0645 \u064a\u062a\u0645 \u062a\u0642\u0633\u064a\u0645 \u0647\u0630\u0647 \u0627\u0644\u0646\u062a\u064a\u062c\u0629 \u0639\u0644\u0649 <code>1<\/code> \u0648 \u0627\u0644 <code>SUM<\/code> \u062a\u0636\u064a\u0641 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u062a\u0628\u0642\u064a\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":453} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"595\" height=\"220\" loading=\"lazy\" alt=\"\u0648\u0638\u0627\u0626\u0641 SUM \u0648 COUNTIF \u0641\u064a Excel\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041312_87_\u0643\u064a\u0641\u064a\u0629-\u062d\u0633\u0627\u0628-\u0627\u0644\u0642\u064a\u0645-\u0627\u0644\u0641\u0631\u064a\u062f\u0629-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041312_87_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AD%D8%B3%D8%A7%D8%A8-%D8%A7%D9%84%D9%82%D9%8A%D9%85-%D8%A7%D9%84%D9%81%D8%B1%D9%8A%D8%AF%D8%A9-%D9%81%D9%8A-Microsoft-Excel.png?resize=595%2C220&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":693} --><\/p>\n<p>\u0639\u0644\u0649 \u063a\u0631\u0627\u0631 \u0627\u0644\u0637\u0631\u064a\u0642\u0629 \u0627\u0644\u0623\u0648\u0644\u0649\u060c \u0642\u062f \u062a\u0648\u0627\u062c\u0647 \u0645\u0634\u0643\u0644\u0627\u062a \u0625\u0630\u0627 \u0643\u0627\u0646 \u0644\u062f\u064a\u0643 \u0641\u0631\u0627\u063a\u0627\u062a \u0641\u064a \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0637\u0631\u064a\u0642\u0629. \u0641\u0642\u0637\u060c \u0633\u062a\u062a\u0644\u0642\u0649 \u0627\u0644\u062e\u0637\u0623 #DIV\/0! \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0642\u064a\u0645\u0629 \u0641\u0631\u064a\u062f\u0629 \u0625\u0636\u0627\u0641\u064a\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":879} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":true,\"currentRuleCount\":900,\"actualCount\":879,\"hasActualCountMetThreshold\":true,\"countRemainingForInjection\":21,\"nextBlockCount\":61,\"hasCountRemainingForInjectionMetThreshold\":true,\"nextCount\":940} --><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":4,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":4,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":900} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":4,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":true,\"actualCount\":0} --><\/p>\n<p>\u0648\u0644\u062d\u0644 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0643\u0644\u0629\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0635\u064a\u063a\u0629 \u0627\u0644\u062a\u0627\u0644\u064a\u0629:<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":40} --><\/p>\n<pre>=SUM((A2:A5&lt;&gt;\"\")\/COUNTIF(A2:A5,A2:A5&amp;\"\"))<\/pre>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":111} --><\/p>\n<p>\u0627\u0644\u062c\u0632\u0621 \u0627\u0644\u0625\u0636\u0627\u0641\u064a \u0644\u0640 <code>COUNTIF<\/code> \u062a\u0642\u0648\u0645 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0628\u0631\u0628\u0637 \u0633\u0644\u0633\u0644\u0629 \u0641\u0627\u0631\u063a\u0629 \u0644\u0645\u0646\u0639 \u0638\u0647\u0648\u0631 \u0627\u0644\u0623\u0635\u0641\u0627\u0631 \u0641\u064a \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0644\u0623\u0646\u0643 \u0644\u0627 \u062a\u0633\u062a\u0637\u064a\u0639 \u0627\u0644\u0642\u0633\u0645\u0629 \u0639\u0644\u0649 \u0627\u0644\u0635\u0641\u0631. \u0627\u0644\u062c\u0632\u0621 \u0627\u0644\u0625\u0636\u0627\u0641\u064a \u0644\u0640 <code>SUM<\/code> \u062a\u0636\u064a\u0641 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u062a\u064a \u0644\u0627 \u062a\u0633\u0627\u0648\u064a \u0641\u0631\u0627\u063a\u064b\u0627. \u0643\u0644 \u0647\u0630\u0627 \u064a\u0648\u0641\u0631 \u0639\u062f\u062f \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u0645\u064a\u0632\u0629 \u0648\u0644\u0627 \u064a\u062d\u0633\u0628 \u0627\u0644\u0641\u0631\u0627\u063a\u0627\u062a \u0639\u0644\u0649 \u0623\u0646\u0647\u0627 \u0641\u0631\u064a\u062f\u0629.<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":431} --><\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img image-expandable img-article-item\">\n<figure><img data-recalc-dims=\"1\" decoding=\"async\" width=\"650\" height=\"210\" loading=\"lazy\" alt=\"\u062a\u0645 \u062a\u0635\u0641\u064a\u0629 SUM \u0648COUNTIF\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041313_485_\u0643\u064a\u0641\u064a\u0629-\u062d\u0633\u0627\u0628-\u0627\u0644\u0642\u064a\u0645-\u0627\u0644\u0641\u0631\u064a\u062f\u0629-\u0641\u064a-Microsoft-Excel.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/1726041313_485_%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AD%D8%B3%D8%A7%D8%A8-%D8%A7%D9%84%D9%82%D9%8A%D9%85-%D8%A7%D9%84%D9%81%D8%B1%D9%8A%D8%AF%D8%A9-%D9%81%D9%8A-Microsoft-Excel.png?resize=650%2C210&#038;ssl=1\" style=\"height:auto;max-width:100%\" title=\"\">  <\/figure>\n<\/p><\/div>\n<\/p><\/div>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":671} --><\/p>\n<p>\u0644\u0627 \u064a\u0646\u0628\u063a\u064a \u0623\u0646 \u064a\u0643\u0648\u0646 \u0627\u0644\u0639\u062b\u0648\u0631 \u0639\u0644\u0649 \u0642\u064a\u0645 \u0641\u0631\u064a\u062f\u0629 \u0641\u064a Excel \u0645\u0647\u0645\u0629 \u0635\u0639\u0628\u0629. \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0648\u0627\u0644\u0635\u064a\u063a \u0647\u0646\u0627\u060c \u064a\u062c\u0628 \u0623\u0646 \u062a\u0631\u0649 \u062a\u0644\u0643 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u0645\u064a\u0632\u0629 \u0641\u064a \u0648\u0642\u062a \u0642\u0635\u064a\u0631!<\/p>\n<p><!-- No repeatable ad for zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"none\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"actualCount\":833} --><\/p>\n<p><span class=\"related-single\">\u0630\u0627\u062a \u0635\u0644\u0629: \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0645\u0642\u0627\u0628\u0644 \u0627\u0644\u0635\u064a\u063a \u0641\u064a Microsoft Excel: \u0645\u0627 \u0647\u0648 \u0627\u0644\u0641\u0631\u0642\u061f<\/span><\/p>\n<p><!-- Repeatable debug data: {\"injection\":\"before\",\"adPosition\":5,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":5,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":911} --><!-- Zone: character count repeatable. --><!-- Repeatable debug data: {\"injection\":\"after\",\"adPosition\":6,\"startingPoint\":0,\"skipEvery\":null,\"nbrPlacementFilledEachSkip\":6,\"nbrPlacementsScanned\":5,\"ruleCount\":900,\"degradationStartingPoint\":1,\"stopAds\":null,\"isEarlyInjection\":false,\"actualCount\":0} --><br \/>\n<!-- Repeatable debug data: {\"isEarlyInjection\":false,\"currentRuleCount\":900,\"actualCount\":0,\"hasActualCountMetThreshold\":null,\"countRemainingForInjection\":null,\"nextBlockCount\":null,\"hasCountRemainingForInjectionMetThreshold\":null} -->\n <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0631\u0648\u0627\u0628\u0637 \u0633\u0631\u064a\u0639\u0629 \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 COUNTA \u0648UNIQUE \u0627\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u062f\u0627\u0644\u062a\u064a\u0646 SUM \u0648COUNTIF \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 COUNT \u0648\u0627\u0644\u0627\u062e\u062a\u0644\u0627\u0641\u0627\u062a \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0647\u0627 \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0623\u0631\u0642\u0627\u0645. \u0648\u0644\u0643\u0646 \u0645\u0627\u0630\u0627 \u0644\u0648 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0645\u0645\u064a\u0632\u0629 \u0641\u0642\u0637 \u0641\u064a \u0646\u0637\u0627\u0642 \u062e\u0644\u0627\u064a\u0627\u061f \u0633\u0646\u0639\u0631\u0636 \u0644\u0643 \u0637\u0631\u064a\u0642\u062a\u064a\u0646 \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a Excel. \u062a\u0633\u062a\u062e\u062f\u0645 \u0627\u0644\u0637\u0631\u064a\u0642\u062a\u0627\u0646 \u0627\u0644\u0644\u062a\u0627\u0646 \u0633\u0646\u0634\u0631\u062d\u0647\u0645\u0627 \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0648\u0638\u0627\u0626\u0641 \u0648\u0627\u0644\u0627\u062e\u062a\u0644\u0627\u0641\u0627\u062a \u0641\u064a \u062f\u0627\u0644\u0629 COUNT. \u0648\u0644\u0623\u0646 &#8230; <a title=\"\u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a Microsoft Excel\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/%d9%83%d9%8a%d9%81%d9%8a%d8%a9-%d8%ad%d8%b3%d8%a7%d8%a8-%d8%a7%d9%84%d9%82%d9%8a%d9%85-%d8%a7%d9%84%d9%81%d8%b1%d9%8a%d8%af%d8%a9-%d9%81%d9%8a-microsoft-excel\/\" aria-label=\"Read more about \u0643\u064a\u0641\u064a\u0629 \u062d\u0633\u0627\u0628 \u0627\u0644\u0642\u064a\u0645 \u0627\u0644\u0641\u0631\u064a\u062f\u0629 \u0641\u064a Microsoft Excel\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":68992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[39,288,226],"class_list":["post-68991","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","tag-microsoft","tag-microsoft-excel","tag-microsoft-office"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2024\/09\/%D9%83%D9%8A%D9%81%D9%8A%D8%A9-%D8%AD%D8%B3%D8%A7%D8%A8-%D8%A7%D9%84%D9%82%D9%8A%D9%85-%D8%A7%D9%84%D9%81%D8%B1%D9%8A%D8%AF%D8%A9-%D9%81%D9%8A-Microsoft-Excel.jpg?fit=1200%2C675&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/68991","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/comments?post=68991"}],"version-history":[{"count":0,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/68991\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/68992"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=68991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=68991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=68991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}