{"id":6573,"date":"2023-01-08T00:03:56","date_gmt":"2023-01-07T20:33:56","guid":{"rendered":"https:\/\/officebaz.ir\/ex\/?p=6573"},"modified":"2024-05-26T10:11:48","modified_gmt":"2024-05-26T06:41:48","slug":"%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84\/","title":{"rendered":"\u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title ez-toc-toggle\" style=\"cursor:pointer\">\u0641\u0647\u0631\u0633\u062a \u0645\u062d\u062a\u0648\u0627<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84\/#%D9%85%D8%AB%D8%A7%D9%84_%D8%B3%D8%A7%D8%AF%D9%87_%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS_%D8%A7%DA%A9%D8%B3%D9%84\" >\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS_%D8%A8%D8%A7_%D8%B4%D8%B1%D8%B7_%D8%B9%D8%AF%D8%AF%DB%8C\" >\u062a\u0627\u0628\u0639 SUMIFS \u0628\u0627 \u0634\u0631\u0637 \u0639\u062f\u062f\u06cc<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS_%D8%A7%DA%A9%D8%B3%D9%84_%D8%A8%D9%87_%D9%87%D9%85%D8%B1%D8%A7%D9%87_%DA%86%D9%86%D8%AF_%D8%B4%D8%B1%D8%B7\" >\u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0686\u0646\u062f \u0634\u0631\u0637<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/officebaz.ir\/ex\/%d8%aa%d8%a7%d8%a8%d8%b9-sumifs-%d8%a7%da%a9%d8%b3%d9%84\/#%DA%A9%D8%A7%D8%B1%D8%A7%DA%A9%D8%AA%D8%B1%D9%87%D8%A7%DB%8C_%D8%AE%D8%A7%D8%B5_%D8%AF%D8%B1_%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS\" >\u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u062f\u0631 \u062a\u0627\u0628\u0639 SUMIFS<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84_%D8%B3%D8%A7%D8%AF%D9%87_%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0634\u0628\u06cc\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u0645\u0648\u062c\u0648\u062f\u06cc \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0633\u0627\u0632\u0646\u062f\u0647 \u0622\u0646\u0647\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 I2 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0633\u0627\u0632\u0646\u062f\u0647 Green \u00a0\u0645\u06cc \u0628\u0627\u0634\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,D3:D12,I2)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1297\" height=\"728\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS1-1.png\" alt=\"\u062a\u0627\u0628\u0639 SUMIFS\" class=\"wp-image-9339\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS1-1.png 1297w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS1-1-300x168.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS1-1-1024x575.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS1-1-768x431.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS1-1-600x337.png 600w\" sizes=\"(max-width: 1297px) 100vw, 1297px\" \/><\/figure>\n\n\n<p>\u0646\u06a9\u062a\u0647: \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0631 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0633\u0648\u0645 \u0627\u0632 \u06cc\u06a9 \u0645\u0642\u062f\u0627\u0631 \u0645\u062a\u0646\u06cc \u062b\u0627\u0628\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u062f\u0627\u062e\u0644 \u06a9\u0648\u062a\u06cc\u0634\u0646 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645 \u0648 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc\u0628\u06cc\u0646\u06cc\u062f \u0628\u0647 \u062d\u0631\u0648\u0641 \u06a9\u0648\u0686\u06a9 \u0648 \u0628\u0632\u0631\u06af \u0647\u0645 \u062d\u0633\u0627\u0633 \u0646\u06cc\u0633\u062a.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,D3:D12,&quot;green&quot;)<\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS_%D8%A8%D8%A7_%D8%B4%D8%B1%D8%B7_%D8%B9%D8%AF%D8%AF%DB%8C\"><\/span>\u062a\u0627\u0628\u0639 SUMIFS \u0628\u0627 \u0634\u0631\u0637 \u0639\u062f\u062f\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<p dir=\"RTL\" style=\"text-align: justify; direction: rtl; unicode-bidi: embed;\"><span lang=\"FA\" style=\"font-family: 'IRANYekanFN',sans-serif;\">\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0647\u0645\u0627\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0628\u0644\u06cc \u0631\u0627 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0648\u062c\u0648\u062f\u06cc \u0622\u0646\u0647\u0627 \u0628\u0632\u0631\u06af\u062a\u0631 \u0627\u0632 <\/span><span dir=\"LTR\" style=\"font-family: 'IRANYekanFN',sans-serif;\">30<\/span><span lang=\"FA\" style=\"font-family: 'IRANYekanFN',sans-serif;\"> \u0627\u0633\u062a \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 .<\/span><\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,F3:F12,&quot;&gt;30&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS3-1024x575.png\" alt=\"\u062a\u0627\u0628\u0639 SUMIFS \u0628\u0627 \u0634\u0631\u0637 \u0639\u062f\u062f\u06cc \u062b\u0627\u0628\u062a\" class=\"wp-image-9341\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS3-1024x575.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS3-300x168.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS3-768x431.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS3-600x337.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS3.png 1297w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u062d\u0627\u0644\u0627 \u0627\u06af\u0631 \u062c\u0648\u0631\u06cc \u0628\u0627\u0634\u062f \u06a9\u0647 \u0639\u062f\u062f 30 \u062b\u0627\u0628\u062a \u0646\u0628\u0627\u0634\u062f \u0648 \u0628\u0627\u06cc\u062f \u062c\u0645\u0639 \u0645\u0648\u062c\u0648\u062f\u06cc \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u0622\u0646\u0647\u0627 \u06a9\u0645\u062a\u0631 \u0627\u0632 \u0645\u0642\u062f\u0627\u0631\u06cc \u0628\u0627\u0634\u062f \u06a9\u0647 \u0645\u062b\u0644\u0627 \u062f\u0631 I2 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0628\u0627\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0628\u0646\u0648\u06cc\u0633\u06cc\u0645.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,F3:F12,&quot;&gt;&quot;&amp;I2)<\/pre><\/div>\n\n\n<p>\u062d\u0627\u0644 \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u0641\u0631\u0648\u0634 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0642\u06cc\u0645\u062a \u062e\u0631\u06cc\u062f \u0622\u0646 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u06cc\u06a9 \u0639\u062f\u062f \u062b\u0627\u0628\u062a \u0628\u0627\u0634\u062f \u060c \u0645\u062b\u0644\u0627 \u0639\u062f\u062f 20 \u0628\u0627\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0628\u0646\u0648\u06cc\u0633\u06cc\u0645 .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,F3:F12,20)<\/pre><\/div>\n\n\n<p>\u062f\u0631 \u0641\u0631\u0645\u0648\u0644 \u0628\u0627\u0644\u0627 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u0628\u06cc\u0646\u06cc\u062f \u060c \u0686\u0648\u0646 \u0645\u0648\u0631\u062f \u0634\u0631\u0637 \u0645\u0627 \u0639\u062f\u062f \u062b\u0627\u0628\u062a \u0647\u0633\u062a \u0647\u0645\u0627\u0646 \u0639\u062f\u062f \u0645\u0633\u062a\u0642\u06cc\u0645\u0627 \u0628\u062f\u0648\u0646 \u06a9\u0648\u062a\u06cc\u0634\u0646 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 \u0645\u062a\u0646\u06cc \u0628\u0648\u062f \u0645\u0627\u0646\u0646\u062f \u0645\u062b\u0627\u0644 \u0627\u0648\u0644 \u0628\u0627\u06cc\u062f \u062f\u0627\u062e\u0644 \u06a9\u0648\u062a\u06cc\u0634\u0646 \u0646\u0648\u0634\u062a\u0647 \u0645\u06cc \u0634\u062f.<\/p>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS_%D8%A7%DA%A9%D8%B3%D9%84_%D8%A8%D9%87_%D9%87%D9%85%D8%B1%D8%A7%D9%87_%DA%86%D9%86%D8%AF_%D8%B4%D8%B1%D8%B7\"><\/span>\u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0686\u0646\u062f \u0634\u0631\u0637<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0647\u0645\u0627\u0646 \u0645\u062b\u0627\u0644 \u0642\u0628\u0644\u06cc \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0633\u0627\u0632\u0646\u062f\u0647 \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u0628\u0631 \u00a0\u0645\u0642\u062f\u0627\u0631 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u062f\u0631 I2 \u00a0\u0628\u0627\u06cc\u062f \u0648 \u062c\u0645\u0639 \u0645\u0648\u062c\u0648\u062f\u06cc \u0622\u0646\u0647\u0627 \u06a9\u0645\u062a\u0631 \u0627\u0632 20 \u0639\u062f\u062f \u0628\u0627\u0634\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,D3:D12,I2,F3:F12,&quot;&lt;20&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS4-1024x578.png\" alt=\"\u062a\u0627\u0628\u0639 SUMIFS \u0628\u0627 \u0686\u0646\u062f \u0634\u0631\u0637\" class=\"wp-image-9344\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS4-1024x578.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS4-300x169.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS4-768x433.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS4-600x338.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS4.png 1294w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u0645\u062b\u0627\u0644 \u062f\u06cc\u06af\u0631\u06cc \u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u0628\u0647\u062a\u0631 \u062a\u0627\u0628\u0639 SUMIFS \u00a0\u0628\u0627 \u0686\u0646\u062f \u0634\u0631\u0637 \u060c \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0644\u06cc\u0633\u062a\u06cc \u0645\u0634\u0627\u0628\u0647 \u0644\u06cc\u0633\u062a \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u062f \u0648 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u062f \u0645\u062c\u0645\u0648\u0639 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc \u06af\u0631\u0648\u0639 \u0644\u0628\u0646\u06cc\u0627\u062a \u06a9\u0647 \u06a9\u0645\u062a\u0631 \u0627\u0632 10 \u0631\u0648\u0632 \u0628\u0647 \u0627\u0646\u0642\u0636\u0627\u06cc \u0622\u0646\u0647\u0627 \u0628\u0627\u0642\u06cc \u0645\u0627\u0646\u062f\u0647 \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F14,B3:B14,I2,E3:E14,&quot;&lt;10&quot;,E3:E14,&quot;&gt;0&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"603\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS5-1024x603.png\" alt=\"\u062a\u0627\u0631\u06cc\u062e \u0627\u0646\u0642\u0636\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 SUMIFS\" class=\"wp-image-9346\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS5-1024x603.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS5-300x177.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS5-768x452.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS5-600x353.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS5.png 1297w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%DA%A9%D8%A7%D8%B1%D8%A7%DA%A9%D8%AA%D8%B1%D9%87%D8%A7%DB%8C_%D8%AE%D8%A7%D8%B5_%D8%AF%D8%B1_%D8%AA%D8%A7%D8%A8%D8%B9_SUMIFS\"><\/span>\u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u062f\u0631 \u062a\u0627\u0628\u0639 SUMIFS<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0645\u062c\u0645\u0648\u0639 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0634\u0631\u062d \u06a9\u0627\u0644\u0627\u06cc \u0622\u0646\u0647\u0627 \u0634\u0627\u0645\u0644 \u06a9\u0644\u0645\u0647 &#8220;\u06a9\u06cc\u0633&#8221; \u0628\u0627\u0634\u062f . \u062f\u0631 \u0627\u06cc\u0646\u0635\u0648\u0631\u062a \u0628\u0627\u06cc\u062f \u0627\u0632 \u0648\u0627\u06cc\u0644\u062f\u06a9\u0627\u0631\u062a\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,E3:E12,&quot;*&quot;&amp;&quot;\u06a9\u06cc\u0633&quot;&amp;&quot;*&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS6-1024x576.png\" alt=\"\" class=\"wp-image-9348\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS6-1024x576.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS6-300x169.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS6-768x432.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS6-600x337.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS6.png 1297w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u062d\u0627\u0644\u0627 \u0627\u06af\u0631 \u06a9\u0644\u0645\u0647 \u06a9\u06cc\u0633 \u062b\u0627\u0628\u062a \u0646\u0628\u0627\u0634\u062f \u0648 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0634\u0627\u0645\u0644 \u0645\u062a\u0646\u06cc \u0628\u0627\u0634\u062f \u06a9\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 I2 \u0646\u0648\u0634\u062a\u0647 \u0627\u0634\u062a \u0628\u0627\u06cc\u062f \u0641\u0631\u0645\u0648\u0644 \u0631\u0627 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,E3:E12,&quot;*&quot;&amp;i2&amp;&quot;*&quot;)<\/pre><\/div>\n\n\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644 \u062c\u0645\u0639 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0634\u0631\u0648\u0639 \u0634\u0631\u062d \u06a9\u0627\u0644\u0627\u06cc \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u0628\u0631 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0627\u06cc \u0628\u0627\u0634\u062f \u06a9\u0647 \u062f\u0631 I2 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0641\u0631\u0648\u0644 \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,E3:E12,&quot;*&quot;&amp;i2)<\/pre><\/div>\n\n\n<p><strong>\u0646\u06a9\u062a\u0647 \u0645\u0647\u0645 \u062f\u0631 \u062e\u0635\u0648\u0635 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 :<\/strong><\/p>\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u062e\u0648\u062f \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u0647\u0627\u06cc \u062e\u0627\u0635 \u06cc\u0639\u0646\u06cc * \u0648 \u06cc\u0627 ? \u0631\u0627 \u062f\u0631 \u062c\u0633\u062a\u062c\u0648 \u0644\u062d\u0627\u0638 \u06a9\u0646\u06cc\u0645 \u0628\u0627\u06cc\u062f \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 ~ \u0631\u0627 \u0642\u0628\u0644 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 . \u0645\u0648\u0642\u0639\u06cc\u062a ~ \u0632\u06cc\u0631 \u06a9\u0644\u06cc\u06a9 Esc \u06a9\u06cc\u0628\u0648\u0631\u062f \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627\u06cc\u062f \u06a9\u06cc\u0628\u0648\u0631\u062f \u0634\u0645\u0627 \u0627\u0646\u06af\u0644\u06cc\u0633\u06cc \u0628\u0627\u0634\u062f \u0648 \u0622\u0646 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f .<\/p>\n<p>\u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0627\u06cc\u062f \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u062d\u0631\u0648\u0641 \u0641\u0627\u0631\u0633\u06cc \u0648 \u0627\u0646\u06af\u0644\u06cc\u0633\u06cc \u060c \u0639\u0644\u0627\u0645\u062a \u0633\u0648\u0627\u0644 \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0633\u062a \u0648 \u0628\u0627\u06cc\u062f \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0631\u0627 \u0644\u062d\u0627\u0638 \u06a9\u0646\u06cc\u062f .<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0627\u0632 <a href=\"https:\/\/exceljet.net\/functions\/sumifs-function\" target=\"_blank\" rel=\"noopener\">\u062a\u0627\u0628\u0639 SUMIFS<\/a> \u0627\u06a9\u0633\u0644 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0634\u0631\u062d \u0622\u0646\u0647\u0627 \u0634\u0627\u0645\u0644 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631 *\u00a0 \u0645\u06cc \u0628\u0627\u0634\u062f.<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">=SUMIFS(F3:F12,E3:E12,&quot;*&quot;&amp;&quot;~*&quot;&amp;&quot;*&quot;)<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS7-1024x576.png\" alt=\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644\" class=\"wp-image-9352\" style=\"width:840px;height:auto\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS7-1024x576.png 1024w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS7-300x169.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS7-768x432.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS7-600x337.png 600w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/05\/SUMIFS7.png 1297w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<p>\u0641\u0631\u0645\u0648\u0644 \u0628\u0627\u0644\u0627 \u0634\u0627\u06cc\u062f \u06a9\u0645\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0647 \u0646\u0638\u0631 \u0628\u0631\u0633\u062f \u0627\u0645\u0627 \u0627\u06af\u0631 \u0645\u0628\u062d\u062b <a href=\"https:\/\/officebaz.ir\/ex\/wildcard\/#:~:text=%DA%A9%D8%A7%D8%B1%D8%A7%DA%A9%D8%AA%D8%B1%D9%87%D8%A7%DB%8C%20%D8%AE%D8%A7%D8%B5%20%D8%AF%D8%B1%20%D8%A7%DA%A9%D8%B3%D9%84%20%D8%8C%20%D9%88%D8%A7%DB%8C%D9%84%D8%AF%DA%A9%D8%A7%D8%B1%D8%AA&amp;text=%D9%85%D9%86%D8%B8%D9%88%D8%B1%20%D8%A7%D8%B2%20%DA%A9%D8%A7%D8%B1%D8%A7%DA%A9%D8%AA%D8%B1%D9%87%D8%A7%DB%8C%20%D8%AE%D8%A7%D8%B5%20%D8%AF%D8%B1,%DA%A9%D8%A7%D8%B1%DA%A9%D8%B1%D8%AF%20%D8%A2%D9%86%D9%87%D8%A7%20%D8%A2%D8%B4%D9%86%D8%A7%20%D8%AE%D9%88%D8%A7%D9%87%DB%8C%D9%85%20%D8%B4%D8%AF%20.\" target=\"_blank\" rel=\"noopener\">\u0648\u0627\u06cc\u0644\u062f\u06a9\u0627\u0631\u062a\u0647\u0627 \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a> \u0631\u0627 \u062f\u0631\u06a9 \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f \u060c \u0641\u0647\u0645 \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0628\u0631\u0627\u06cc\u062a\u0627\u0646 \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/p>\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;6573&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;7&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.4&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.4\\\/5 - (7 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644&quot;,&quot;width&quot;:&quot;121.2&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 121.2px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.4\/5 - (7 \u0627\u0645\u062a\u06cc\u0627\u0632)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644 \u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0634\u0628\u06cc\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u0645\u0648\u062c\u0648\u062f\u06cc \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0633\u0627\u0632\u0646\u062f\u0647 \u0622\u0646\u0647\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 I2 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0633\u0627\u0632\u0646\u062f\u0647 Green \u00a0\u0645\u06cc \u0628\u0627\u0634\u062f . \u0646\u06a9\u062a\u0647: \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0631 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0633\u0648\u0645 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":6574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":""},"categories":[33],"tags":[161],"class_list":["post-6573","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-function","tag-sumifs"],"acf":[],"author_meta":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"featured_img":"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS-300x169.png","uagb_featured_image_src":{"full":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS.png",1280,720,false],"thumbnail":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS-150x150.png",150,150,true],"medium":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS-300x169.png",300,169,true],"medium_large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS-768x432.png",768,432,true],"large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS-1024x576.png",800,450,true],"1536x1536":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS.png",1280,720,false],"2048x2048":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS.png",1280,720,false],"gform-image-choice-sm":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS.png",300,169,false],"gform-image-choice-md":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS.png",400,225,false],"gform-image-choice-lg":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/01\/SUMIFS.png",600,338,false]},"uagb_author_info":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"uagb_comment_info":9,"uagb_excerpt":"\u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644 \u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc\u06cc \u0634\u0628\u06cc\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u062f\u0627\u0631\u06cc\u0645 \u0648 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0645\u0639 \u0645\u0648\u062c\u0648\u062f\u06cc \u06a9\u0627\u0644\u0627\u0647\u0627\u06cc\u06cc \u0631\u0627 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 \u06a9\u0647 \u0633\u0627\u0632\u0646\u062f\u0647 \u0622\u0646\u0647\u0627 \u062f\u0631 \u0633\u0644\u0648\u0644 I2 \u0648\u0627\u0631\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0633\u0627\u0632\u0646\u062f\u0647 Green \u00a0\u0645\u06cc \u0628\u0627\u0634\u062f . \u0646\u06a9\u062a\u0647: \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u0634\u062a\u0647 \u0634\u062f\u0647 \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0631 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0633\u0648\u0645&hellip;","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">\u062a\u0648\u0627\u0628\u0639 \u0627\u06a9\u0633\u0644<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/function\/\" class=\"advgb-post-tax-term\">SUMIFS<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">SUMIFS<\/span>"]}},"comment_count":"9","relative_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 4 \u0633\u0627\u0644 \u067e\u06cc\u0634","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 2 \u0633\u0627\u0644 \u067e\u06cc\u0634"},"absolute_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 18 \u062f\u06cc 1401","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 6 \u062e\u0631\u062f\u0627\u062f 1403"},"absolute_dates_time":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 18 \u062f\u06cc 1401 12:03 \u0642.\u0638","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 6 \u062e\u0631\u062f\u0627\u062f 1403 10:11 \u0642.\u0638"},"featured_img_caption":"\u062a\u0627\u0628\u0639 SUMIFS \u0627\u06a9\u0633\u0644","series_order":"","_links":{"self":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/6573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/comments?post=6573"}],"version-history":[{"count":0,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/6573\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media\/6574"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media?parent=6573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/categories?post=6573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/tags?post=6573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}