{"id":30601,"date":"2023-04-22T20:01:00","date_gmt":"2023-04-22T15:31:00","guid":{"rendered":"https:\/\/wpadmin.maktabkhooneh.org\/mag\/?p=30601"},"modified":"2026-04-06T17:52:48","modified_gmt":"2026-04-06T14:22:48","slug":"averageif-in-excel","status":"publish","type":"post","link":"https:\/\/maktabkhooneh.org\/mag\/averageif-in-excel\/","title":{"rendered":"\u06a9\u0627\u0631 \u0628\u0627 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644"},"content":{"rendered":"\n<p>\u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u062e\u0627\u0635\u06cc \u062f\u0627\u0631\u0646\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 AVERAGEIF \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06af\u0631 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0647\u0645\u06cc\u0634\u06af\u06cc \u0628\u0631\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0627\u0634\u06cc\u062f\u060c \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f \u0639\u0627\u0644\u06cc \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0622\u06af\u0627\u0647 \u0647\u0633\u062a\u06cc\u062f. \u062f\u0631 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0645\u062c\u0645\u0648\u0639 \u0647\u0645\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u06af\u0631\u0641\u062a\u0647 \u0648 \u0628\u0631 \u062a\u0639\u062f\u0627\u062f \u0622\u0646\u200c\u0647\u0627 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0627\u0645\u0627 \u06af\u0627\u0647\u06cc \u0645\u0648\u0642\u0639\u06cc\u062a\u06cc \u067e\u06cc\u0634 \u0645\u06cc\u200c\u0622\u06cc\u062f \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a \u062a\u0639\u062f\u0627\u062f\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u06a9\u0646\u0627\u0631 \u06af\u0630\u0627\u0634\u062a\u0647 \u0648 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u062a\u0639\u062f\u0627\u062f\u06cc \u062f\u06cc\u06af\u0631 \u0631\u0627 \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0628\u0631\u062e\u06cc \u0627\u0632 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062e\u0627\u0635 \u0631\u0627 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f.<\/p>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0686\u0646\u06cc\u0646 \u06a9\u0627\u0631\u06cc \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u062a\u0627\u0628\u0639 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u062f \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0628\u062f\u0647\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0632\u0645\u0627\u0646 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0627\u0628\u0639 averageif \u0648\u0627\u0631\u062f \u0639\u0645\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u062f\u0627\u0634\u062a\u0646 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u062e\u0627\u0635\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f. \u0628\u0647 \u0639\u0644\u0627\u0648\u0647 \u0627\u0639\u0645\u0627\u0644 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0645\u0627\u0646\u0646\u062f \u062a\u0627\u0631\u06cc\u062e\u060c \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc \u0648 \u0645\u062a\u0646 \u0645\u0645\u06a9\u0646 \u0634\u062f\u0647 \u0627\u0633\u062a. \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0686\u0646\u06cc\u0646 \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u062d\u062b AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0632 \u062c\u0645\u0644\u0647 \u0627\u0647\u062f\u0627\u0641 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u0634\u0645\u0627 \u0647\u0645 \u0627\u06af\u0631 \u06a9\u0646\u062c\u06a9\u0627\u0648 \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0647\u0633\u062a\u06cc\u062f \u0628\u0627 \u0627\u062f\u0627\u0645\u0647 \u0645\u0637\u0644\u0628 \u0647\u0645\u0631\u0627\u0647 \u0634\u0648\u06cc\u062f.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0648\u062c\u0648\u062f \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0627\u06cc \u0627\u0632 \u0633\u0644\u0648\u0644\u200c\u0647\u0627 \u0631\u0627 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0628\u0627 \u06a9\u0645\u06a9 \u0622\u0646 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u0634\u0645\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0634\u0648\u0646\u062f\u060c \u0628\u0647 \u062a\u0627\u0628\u0639 averageif deutsch \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a. \u062f\u0631 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u062f\u0644\u0627\u0644\u200c\u0647\u0627\u06cc\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0622\u0646 \u062a\u0633\u0644\u0637 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f. \u0627\u0633\u062a\u062f\u0644\u0627\u0644\u200c\u0647\u0627 \u0639\u0628\u0627\u0631\u062a\u200c\u0627\u0646\u062f \u0627\u0632:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Range: \u0628\u0631\u0627\u06cc \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0634\u0648\u0646\u062f\u060c \u0637\u0631\u0627\u062d\u06cc\u200c\u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n\n\n\n<li>Criteria: \u0628\u0631\u0627\u06cc \u0645\u06cc\u0627\u0646\u06af\u06cc\u0631\u06cc \u0628\u0631\u0627\u0633\u0627\u0633 \u06a9\u062f\u0627\u0645 \u0645\u0639\u06cc\u0627\u0631 \u062a\u0635\u0645\u06cc\u0645 \u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u200c\u06af\u06cc\u0631\u06cc \u062f\u0627\u0631\u06cc\u062f. \u0627\u06cc\u0646 \u0627\u0633\u062a\u062f\u0644\u0627\u0644 \u0628\u0647 \u0634\u0645\u0627 \u06a9\u0645\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/li>\n\n\n\n<li>sum range: \u062f\u0631 \u0627\u06cc\u0646 \u06af\u0632\u06cc\u0646\u0647 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u0628\u0627 \u0647\u0645 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0634\u0648\u0646\u062f\u060c \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f. \u0686\u0646\u0627\u0646\u0686\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632 \u0634\u0631 \u0622\u0646 \u062e\u0644\u0627\u0635 \u0634\u0648\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0645\u062d\u062f\u0648\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u0645\u0639\u06cc \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0628\u06af\u06cc\u0631\u06cc\u062f.<\/li>\n<\/ul>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><style><\/style><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"156\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/03\/How-to-Edit-Legend-in-Excel-770x400-1-300x156.png.webp\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"legend \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0686\u06cc\u0633\u062a \u0648 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u061f\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/03\/How-to-Edit-Legend-in-Excel-770x400-1-300x156.png.webp 300w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/03\/How-to-Edit-Legend-in-Excel-770x400-1-768x399.png.webp 768w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/03\/How-to-Edit-Legend-in-Excel-770x400-1.png 770w\" data-sizes=\"(max-width: 300px) 100vw, 300px\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/156;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/legend-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">legend \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0686\u06cc\u0633\u062a \u0648 \u0686\u06af\u0648\u0646\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u061f<\/a>\n<\/section><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h3>\n\n\n\n<p>\u062a\u0627\u0628\u0639 averageif \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0647\u0645\u0627\u0646\u0646\u062f \u062a\u0648\u0627\u0628\u0639 sumif \u062f\u0631 \u0633\u0644\u0648\u0644 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0642\u0631\u0627\u0631 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u200c\u06af\u06cc\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f\u060c \u062a\u0646\u0647\u0627 \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a \u0628\u0631 \u0631\u0648\u06cc \u0633\u0644\u0648\u0644\u06cc \u06a9\u0647 \u062a\u0627\u0628\u0639 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0644\u06cc\u06a9 \u06a9\u0631\u062f\u0647 \u0648 \u0633\u067e\u0633 \u0641\u0631\u0645\u0648\u0644 averageif \u0631\u0627 \u062f\u0631\u0648\u0646 \u0622\u0646 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f. \u0628\u0631\u0627\u06cc \u0631\u0627\u062d\u062a\u06cc \u062a\u0627\u06cc\u067e \u0641\u0631\u0645\u0648\u0644\u060c \u0627\u0632 \u06a9\u0627\u062f\u0631\u06cc \u0628\u0627 \u0646\u0627\u0645 \u0646\u0648\u0627\u0631 \u0641\u0631\u0645\u0648\u0644 \u06a9\u0647 \u0628\u0627\u0644\u0627\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0648\u0627\u0642\u0639 \u0634\u062f\u0647\u060c \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0627\u0644\u0628\u062a\u0647 \u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646 \u0639\u0645\u0644 \u0628\u0627\u06cc\u062f \u0633\u0644\u0648\u0644 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0631\u062f\u0647 \u0628\u0627\u0634\u06cc\u062f. \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0647\u0645 \u0633\u06cc\u0646\u062a\u06a9\u0633 \u062a\u0627\u0628\u0639 \u0631\u0627 \u0648\u0627\u0631\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f. \u062a\u0627\u0628\u0639 AVERAGEIF \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a \u0648 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0622\u0646 \u0686\u0646\u062f\u0627\u0646 \u0632\u0645\u0627\u0646\u0628\u0631 \u0646\u06cc\u0633\u062a.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644\u200c \u0647\u0627\u06cc\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u062f \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u062f\u0631 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0639\u062f \u0627\u0632 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u06a9\u0644\u06cc\u0627\u062a \u062a\u0627\u0628\u0639 \u0648 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646\u060c \u0646\u0648\u0628\u062a \u0628\u0647 \u0622\u0648\u0631\u062f\u0646 \u0646\u0645\u0648\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\u062f \u062a\u0627\u0628\u0639 averageif \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u06cc\u200c\u0631\u0633\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0627\u0632 \u0628\u0633\u06cc\u0627\u0631\u06cc \u062c\u0647\u0627\u062a \u06a9\u0627\u0645\u0644\u0627\u064b \u0634\u0628\u06cc\u0647 \u062a\u0627\u0628\u0639 SUMIF \u0627\u0633\u062a \u0648 \u062a\u0646\u0647\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u0631\u062d\u0644\u0647 \u0645\u062a\u0641\u0627\u0648\u062a \u0639\u0645\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u06cc\u0634\u062a\u0631 \u0645\u062a\u0648\u062c\u0647 \u0634\u0648\u06cc\u062f\u060c \u0628\u0647 \u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc \u0628\u0639\u062f\u06cc \u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img fetchpriority=\"high\" decoding=\"async\" width=\"750\" height=\"482\" src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif.png\" alt=\"\u06a9\u0627\u0631\u0628\u0631\u062f \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644\" class=\"wp-image-30602\" title=\"\" srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif.png 750w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/averegeif-300x193.png.webp 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u0645\u062b\u0627\u0644 \u0627\u0632 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc<\/h3>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u06a9\u0627\u0631 \u0628\u0627 \u06cc\u06a9 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0648\u0636\u06cc\u062d \u067e\u062a\u0627\u0646\u0633\u06cc\u0644 \u062a\u0627\u0628\u0639 excel averageif deutsch \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u062f. \u0645\u0642\u0627\u062f\u06cc\u0631 \u06f1\u06f0\u060c \u06f3\u060c \u06f4\u060c \u06f6\u060c \u06f7\u060c \u06f2 \u0648 \u06f1\u06f1 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0645\u0633\u0626\u0644\u0647 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0628\u06cc\u0634 \u0627\u0632 \u06f5 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A1:A7 \u0631\u0627 \u062d\u0633\u0627\u0628 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0632\u0645\u0627\u0646 \u0628\u0627\u06cc\u062f \u0633\u0644\u0648\u0644 A9 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f \u0648 \u0634\u0631\u0637 \u200eAVERAGEIF(A1:A7,\u201d&gt;5\u201d)= \u0631\u0627 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f. \u0646\u062a\u06cc\u062c\u0647 \u0627\u0639\u0645\u0627\u0644 \u062a\u0627\u0628\u0639 AVERAGEIF \u0628\u0647 \u0637\u0648\u0631 \u0645\u062a\u0648\u0633\u0637 \u200b\u200b\u06f1\u06f0\u060c \u06f6\u060c \u06f7\u060c \u06f1\u06f1 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u0627\u06cc\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u062f\u0631 \u0633\u0644\u0648\u0644 A9 8.5 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"750\" height=\"572\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif4.png.jpg\" alt=\"\u0622\u0645\u0648\u0632\u0634 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644\" class=\"wp-image-30603 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif4.png.jpg 750w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/averegeif4.png-300x229.jpg.webp 300w\" data-sizes=\"(max-width: 750px) 100vw, 750px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 750px; --smush-placeholder-aspect-ratio: 750\/572;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u062f\u0648 \u0645\u062b\u0627\u0644 \u0627\u0632 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0645\u062a\u0646<\/h3>\n\n\n\n<p>\u062f\u0631 \u0632\u06cc\u0631 \u062f\u0648 \u0645\u062b\u0627\u0644 \u0627\u0632 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0645\u062a\u0646\u06cc \u0628\u0631\u0627\u06cc \u062a\u0627\u0628\u0639 AVERAGEIF \u0628\u0631\u0627\u06cc \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0645\u062a\u0646\u06cc \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n\n\n\n<p>\u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0633\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u0648\u0636\u06cc\u062d \u067e\u062a\u0627\u0646\u0633\u06cc\u0644 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0633\u0646\u0627\u0631\u06cc\u0648\u0647\u0627\u06cc \u0645\u062a\u0646\u06cc \u0628\u06af\u06cc\u0631\u06cc\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u0645\u062a\u0646 Apple &nbsp;\u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A1 \u062a\u0627 A7 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u062d\u0627\u0644 \u0646\u0648\u0628\u062a \u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0627\u0632 \u0645\u062d\u062f\u0648\u062f\u0647 B1 \u062a\u0627 B7 \u0645\u06cc\u200c\u0631\u0633\u062f. \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f \u062a\u0627\u06cc\u067e \u0645\u062a\u0646 \u0634\u0631\u0637\u06cc AVERAGEIF(A1:A7,\u201dApple\u201d.B1:B7)= \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0646\u062a\u06cc\u062c\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A2\u060c A3 \u0648 A7 \u0631\u0627 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 B2\u060c B3 \u0648 B7 \u0627\u0633\u062a\u200c. \u0646\u062a\u06cc\u062c\u0647 \u0646\u06cc\u0632 \u062f\u0631 \u0633\u0644\u0648\u0644 B9 \u0628\u0631\u0627\u06cc \u0634\u0645\u0627 \u06f6 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<p>\u0645\u062b\u0627\u0644 \u0647\u0645\u0627\u0646 \u0635\u0641\u062d\u0647 \u06af\u0633\u062a\u0631\u062f\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0647\u0645\u0627\u0646 \u0645\u062b\u0627\u0644 \u0645\u062a\u0646 \u0634\u0645\u0627\u0631\u0647 \u06f1 \u0627\u0633\u062a. \u062a\u0646\u0647\u0627 \u0628\u0647 \u062c\u0627\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0645\u062a\u0646 Apple\u060c \u0622\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f \u06a9\u0647 \u0628\u0627 \u0645\u062a\u0646 Apple &nbsp;\u0645\u0637\u0627\u0628\u0642\u062a \u0646\u062f\u0627\u0631\u0646\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 AVERAGEIF(A1:A7,\u201d&lt;&gt;Apple\u201d,B1:B7)= \u0634\u0631\u0637 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u062d\u0627\u0644 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1\u060c A4\u060c A5\u060c A6 \u062c\u0627\u06cc \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A2\u060c A3 \u0648 A7 \u0631\u0627 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc\u0646 \u0641\u0631\u0636 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u062f\u0631 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc B1\u060c B4\u060c B5 \u0648 B6 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f. \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0646\u06cc\u0632 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u06f1\u06f0\u060c \u06f6\u060c \u06f7 \u0648 \u06f2 \u06a9\u0647 \u06f6\u200c.\u06f2\u06f5 \u0627\u0633\u062a \u062f\u0631 \u0633\u0644\u0648\u0644 B9 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"750\" height=\"522\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif5.png\" alt=\"\u062a\u0627\u0628\u0639 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644\" class=\"wp-image-30604 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif5.png 750w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/averegeif5-300x209.png.webp 300w\" data-sizes=\"(max-width: 750px) 100vw, 750px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 750px; --smush-placeholder-aspect-ratio: 750\/522;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u06cc\u06a9 \u0645\u062b\u0627\u0644 \u0627\u0632 \u0645\u0639\u06cc\u0627\u0631 \u062a\u0627\u0631\u06cc\u062e<\/h3>\n\n\n\n<p>\u0645\u062b\u0627\u0644 \u062f\u06cc\u06af\u0631 \u0627\u0632 \u06a9\u0627\u0631 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0645\u0639\u06cc\u0627\u0631 \u062a\u0627\u0631\u06cc\u062e \u0627\u0633\u062a \u06a9\u0647 \u062a\u0641\u0627\u0648\u062a\u06cc \u0628\u0627 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0639\u062f\u062f\u06cc \u0648 \u0645\u062a\u0646\u06cc \u0646\u062f\u0627\u0631\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u0645\u062b\u0627\u0644 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A1 \u062a\u0627 A7 \u062a\u0639\u062f\u0627\u062f\u06cc \u062a\u0627\u0631\u06cc\u062e \u0648 \u0645\u0642\u062f\u0627\u0631\u06cc \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f. \u0628\u0627\u06cc\u062f \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u06a9\u0646\u0627\u0631 \u062a\u0627\u0631\u06cc\u062e\u200c\u0647\u0627\u06cc \u0628\u0639\u062f \u0627\u0632 \u06f0\u06f1 \u0645\u0627\u0631\u0633 \u06f2\u06f0\u06f2\u06f1 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f. \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0627\u06cc\u0646 \u0628\u0627\u0631 \u062f\u0633\u062a\u0648\u0631 averageif AVERAGEIF(A1:A7,\u201d&gt; 01 \/03\/ 2021 ,B1:B7)= \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f. \u062f\u0631 \u0627\u06cc\u0646 \u062d\u0627\u0644\u062a \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc A4 \u060cA5 \u060cA6 \u060cA7 \u067e\u0631 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u06a9\u0646\u0627\u0631\u06cc \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0641\u0631\u0627\u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u0647\u0646\u06af\u0627\u0645\u06cc\u200c\u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u06f6\u060c \u06f7\u060c \u06f2 \u0648 \u06f1\u06f1 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0647 \u0634\u0648\u0646\u062f\u060c \u062f\u0631 \u0633\u0644\u0648\u0644 B9 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u06f6.\u06f5 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"300\" height=\"168\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/03\/images.png\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"\u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06af\u0627\u0645 \u0628\u0647 \u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 cell style \u062f\u0631 \u0627\u06a9\u0633\u0644\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/168;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/cell-style-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06af\u0627\u0645 \u0628\u0647 \u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 cell style \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u062a\u0641\u0627\u0648\u062a \u062a\u0627\u0628\u0639 AVERAGEIF \u0628\u0627 \u062f\u06cc\u06af\u0631 \u062a\u0627\u0628\u0639 \u0647\u0627\u06cc \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h2>\n\n\n\n<p>\u062f\u0631 microsoft exel \u062a\u0627\u0628\u0639\u200c\u0647\u0627\u06cc \u06af\u0631\u0648\u0647 average \u0628\u0631\u0627\u06cc \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u200c\u06af\u06cc\u0631\u06cc \u06cc\u0627 \u06af\u0631\u0641\u062a\u0646 \u0645\u0639\u062f\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u0627\u0646\u0648\u0627\u0639 \u0622\u0646\u200c\u0647\u0627 \u0628\u0627 \u06cc\u06a9\u062f\u06cc\u06af\u0631 \u062a\u0641\u0627\u0648\u062a\u200c\u0647\u0627\u06cc \u062c\u0632\u0626\u06cc \u062f\u0627\u0631\u0646\u062f. \u062a\u0627\u0628\u0639 AVERAGE \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u06cc\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0639\u062f\u062f\u06cc \u0631\u0627 \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062e\u0627\u0644\u06cc \u0648 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062d\u0627\u0648\u06cc \u0645\u062a\u0646 \u06cc\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0645\u0646\u0637\u0642\u06cc \u0647\u0633\u062a\u0646\u062f \u0631\u0627 \u0646\u0627\u062f\u06cc\u062f\u0647 \u0645\u06cc\u200c\u06af\u06cc\u0631\u062f. \u062a\u0627\u0628\u0639 AVERAGEA \u0646\u06cc\u0632 \u0645\u0634\u0627\u0628\u0647 AVERAGE \u0627\u0633\u062a \u0648 \u062a\u0646\u0647\u0627 \u0628\u0627 \u06cc\u06a9 \u062a\u0641\u0627\u0648\u062a \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0686\u0646\u06cc\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u06a9\u0647 \u062d\u0627\u0635\u0644 \u062c\u0645\u0639 \u0627\u0639\u062f\u0627\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0631\u0627 \u062a\u0642\u0633\u06cc\u0645\u200c\u0628\u0631 \u062a\u0639\u062f\u0627\u062f \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062d\u0627\u0648\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n\n\n\n<p>\u0628\u0639\u062f \u0627\u0632 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u0627\u0646\u0646\u062f \u062a\u0627\u0628\u0639 if \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0641\u0631\u0635\u062a \u062a\u063a\u06cc\u06cc\u0631 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0628\u0627 \u0628\u0631\u0631\u0633\u06cc \u062a\u062d\u0642\u0642 \u0634\u0631\u0648\u0637 \u0628\u0627 \u06a9\u0645\u06a9 \u062a\u0648\u0627\u0628\u0639 \u200caverageifS \u0648 averageif \u0645\u0645\u06a9\u0646 \u0645\u06cc\u200c\u0634\u0648\u062f. \u200caverageifS \u062f\u0631 \u062d\u0627\u0644\u062a \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062a\u0627\u0628\u0639 \u0628\u0647 \u062c\u0627\u06cc \u06cc\u06a9 \u0634\u0631\u0637 \u0627\u0632 \u0686\u0646\u062f \u0634\u0631\u0637 \u0628\u0647 \u0635\u0648\u0631\u062a \u0647\u0645\u200c\u0632\u0645\u0627\u0646 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u062a\u0627 \u062d\u062f\u0648\u062f\u06cc \u0645\u06cc\u200c\u062a\u0648\u0627\u0646 \u0628\u0647 \u062a\u0627\u0628\u0639 countif \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0634\u0627\u0628\u0647 \u06a9\u0631\u062f. \u062f\u0631 \u0648\u0627\u0642\u0639 \u0627\u06cc\u0646 \u062a\u0641\u0627\u0648\u062a\u06cc \u0627\u0633\u062a \u06a9\u0647 average ifs \u0628\u0627 averageif \u062f\u0627\u0631\u062f. \u062f\u06cc\u06af\u0631 \u062a\u0641\u0627\u0648\u062a \u0627\u06cc\u0646 \u062f\u0648 \u0646\u0648\u0639 \u062a\u0627\u0628\u0639 \u062f\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u062a\u0627\u0628\u0639 AVERAGEIFS\u060c \u0627\u06af\u0631 \u062f\u0631 average_range \u0645\u062a\u0646 \u06cc\u0627 \u0633\u0644\u0648\u0644 \u062e\u0627\u0644\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u067e\u06cc\u0627\u0645 averageifs div\/0 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f. averageif function \u0646\u06cc\u0632 \u062a\u0639\u0631\u06cc\u0641 \u062a\u0627\u0628\u0639 averageif \u0627\u0633\u062a \u06a9\u0647 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc\u200c\u062f\u0647\u062f \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0645\u06a9\u0627\u0646 \u0645\u0631\u06a9\u0632 \u06af\u0631\u0648\u0647\u06cc \u0627\u0632 \u0627\u0639\u062f\u0627\u062f \u062f\u0631 \u06cc\u06a9 \u062a\u0648\u0632\u06cc\u0639 \u0622\u0645\u0627\u0631\u06cc \u0627\u0633\u062a<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" width=\"750\" height=\"518\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif85.png\" alt=\"\u0622\u0645\u0648\u0632\u0634 \u062a\u0627\u0628\u0639 AVERAGEIF\" class=\"wp-image-30605 lazyload\" title=\"\" data-srcset=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2023\/04\/averegeif85.png 750w, https:\/\/maktabkhooneh.org\/mag\/wp-content\/smush-webp\/2023\/04\/averegeif85-300x207.png.webp 300w\" data-sizes=\"(max-width: 750px) 100vw, 750px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 750px; --smush-placeholder-aspect-ratio: 750\/518;\" \/><figcaption><\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u0645\u0632\u0627\u06cc\u0627 \u0648 \u0645\u0639\u0627\u06cc\u0628 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644<\/h3>\n\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u062f\u0627\u0646\u06cc\u062f AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0647 \u0686\u0647 \u062f\u0644\u06cc\u0644 \u0628\u0647 \u0634\u0645\u0627 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0628\u0627\u06cc\u062f \u0645\u0632\u0627\u06cc\u0627 \u0648 \u0645\u0639\u0627\u06cc\u0628 \u0622\u0646 \u0631\u0627 \u0645\u0648\u0631\u062f\u0628\u0631\u0631\u0633\u06cc \u0642\u0631\u0627\u0631 \u062f\u0627\u062f.<\/p>\n\n\n\n<p><strong>\u0645\u0632\u0627\u06cc\u0627\u06cc \u062a\u0627\u0628\u0639 <\/strong><strong>averageif <\/strong><strong>:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0648 \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0622\u0633\u0627\u0646\u200c\u062a\u0631<\/li>\n\n\n\n<li>\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0645\u0644\u06af\u0631\u0647\u0627\u06cc \u0645\u0646\u0637\u0642\u06cc<\/li>\n\n\n\n<li>\u0627\u062c\u0631\u0627\u06cc \u0633\u0631\u06cc\u0639 \u062f\u0633\u062a\u0648\u0631 calculate average<\/li>\n\n\n\n<li>\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u062a\u0627\u0631\u06cc\u062e \u0628\u0647 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0627\u0646\u0639\u0637\u0627\u0641\u200c\u067e\u0630\u06cc\u0631\u06cc \u0628\u0627\u0644\u0627\u06cc \u0622\u0646<\/li>\n<\/ol>\n\n\n\n<p><strong>\u0645\u0639\u0627\u06cc\u0628 \u062a\u0627\u0628\u0639 <\/strong><strong>averageif<\/strong><strong>:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0631\u062e \u062f\u0627\u062f\u0646 \u062e\u0637\u0627 \u0647\u0646\u06af\u0627\u0645 \u062e\u0627\u0644\u06cc \u0628\u0648\u062f\u0646 \u0645\u062d\u062f\u0648\u062f\u0647 \u0648 \u06cc\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0646\u0634\u062f\u0646 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644<\/li>\n\n\n\n<li>\u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0646 \u0635\u0641\u0631 \u062f\u0631 \u0635\u0648\u0631\u062a \u0645\u0634\u062e\u0635 \u0646\u06a9\u0631\u062f\u0646 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627<\/li>\n\n\n\n<li>\u0646\u0627\u062f\u06cc\u062f\u0647 \u06af\u0631\u0641\u062a\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc \u062f\u0627\u0631\u0627\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 TRUE \u06cc\u0627 FALSE<\/li>\n<\/ol>\n\n\n<div class=\"jet-listing-grid--50192\" style=\"\"><section class=\"zht-related-post\" itemscope=\"\" itemtype=\"https:\/\/schema.org\/Article\" role=\"region\"\n  aria-label=\"Related article\">\n  <div class=\"zht-related-post-section-label\">\n    \u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u062a\u0628\u0637\n  <\/div>\n  <img decoding=\"async\" width=\"283\" height=\"178\" data-src=\"https:\/\/maktabkhooneh.org\/mag\/wp-content\/uploads\/2022\/07\/images-1.jpg\" class=\"attachment-medium size-medium wp-post-image lazyload\" alt=\"Referencing in Excel\" title=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 283px; --smush-placeholder-aspect-ratio: 283\/178;\">\n  <a href=\"https:\/\/maktabkhooneh.org\/mag\/referencing-in-excel\/\" class=\"zht-related-post-title\"\n    itemprop=\"headline\" target=\"_blank\">\u0646\u062d\u0648\u0647 \u0631\u0641\u0631\u0646\u0633 \u062f\u0647\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>\n<\/section><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u0633\u062e\u0646 \u067e\u0627\u06cc\u0627\u0646\u06cc<\/h2>\n\n\n\n<p>\u062a\u0627\u0628\u0639 AVERAGEIF \u0627\u0632 \u062c\u0645\u0644\u0647 \u062a\u0648\u0627\u0628\u0639\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0647\u0646\u06af\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646\u200c\u06af\u06cc\u0631\u06cc \u0648\u0627\u0631\u062f \u0639\u0645\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0631\u062e\u0644\u0627\u0641 \u062a\u0648\u0627\u0628\u0639 \u0633\u0627\u062f\u0647\u200c\u062a\u0631 \u0641\u0631\u0635\u062a \u0627\u06cc\u062c\u0627\u062f \u0634\u0631\u0637 \u0648 \u0634\u0631\u0648\u0637 \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a. \u0628\u0647 \u0627\u06cc\u0646 \u062a\u0631\u062a\u06cc\u0628 \u06a9\u0647 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0628\u0631\u0627\u0633\u0627\u0633 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc\u06cc \u0639\u062f\u062f\u06cc\u060c \u0645\u062a\u0646\u06cc \u06cc\u0627 \u062a\u0627\u0631\u06cc\u062e\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f. \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631 \u0628\u0627 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0628\u0647 \u0622\u0645\u0648\u0632\u0634 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0646\u06cc\u0627\u0632 \u067e\u06cc\u062f\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u0622\u0633\u0627\u0646\u062a\u0631\u06cc\u0646 \u0631\u0627\u0647 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0627\u06a9\u0633\u0644<\/h3>\n\n\n\n<p>\u0627\u06af\u0631 \u0628\u0647 \u0641\u06a9\u0631 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0627\u06a9\u0633\u0644 \u0647\u0633\u062a\u06cc\u062f \u0648 \u062f\u0648\u0633\u062a \u062f\u0627\u0631\u06cc\u062f \u062a\u0645\u0627\u0645 \u0645\u0628\u0627\u062d\u062b \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u06a9\u0627\u0645\u0644\u0627\u064b \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u0628\u06cc\u0627\u0645\u0648\u0632\u06cc\u062f\u060c \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u0627\u0632 \u062f\u0648\u0631\u0647\u200c\u0647\u0627\u06cc \u062c\u0627\u0645\u0639 \u0627\u06a9\u0633\u0644 \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u062f\u0631 \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647 \u0627\u0646\u0648\u0627\u0639 \u062f\u0648\u0631\u0647<a href=\"https:\/\/maktabkhooneh.org\/learn\/excel\/\">&nbsp;\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/a> \u0627\u0632 \u0645\u0642\u062f\u0645\u0627\u062a\u06cc \u062a\u0627 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0648 \u0628\u0647 \u0635\u0648\u0631\u062a \u0639\u0645\u0644\u06cc \u0648 \u06af\u0627\u0645\u200c\u0628\u0647\u200c\u06af\u0627\u0645 \u0634\u0645\u0627 \u0631\u0627 \u0628\u0647 \u0641\u0631\u062f\u06cc \u062d\u0631\u0641\u0647\u200c\u0627\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0647\u0645\u200c\u0627\u06a9\u0646\u0648\u0646 \u0628\u0627\u0632\u0627\u0631 \u06a9\u0627\u0631 \u0645\u062a\u062e\u0635\u0635\u06cc\u0646 \u0627\u06a9\u0633\u0644 \u0628\u0633\u06cc\u0627\u0631 \u062f\u0627\u063a \u0648 \u0633\u0631\u0645\u0627\u06cc\u0647\u200c\u06af\u0630\u0627\u0631\u06cc \u062f\u0631 \u0686\u0646\u06cc\u0646 \u0645\u0647\u0627\u0631\u062a\u06cc \u0627\u0631\u0632\u0634\u200c\u0627\u0641\u0632\u0648\u062f\u0647 \u0628\u0627\u0644\u0627\u06cc\u06cc \u062f\u0627\u0631\u062f.<\/p>\n\n\n\n<p>\u0647\u0645\u0686\u06cc\u0646 \u062f\u0631 \u0645\u06a9\u062a\u0628 \u062e\u0648\u0646\u0647 \u0627\u0646\u0648\u0627\u0639 \u062f\u0648\u0631\u0647&nbsp;<a href=\"https:\/\/maktabkhooneh.org\/learn\/advanced-excel\/\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647<\/a>&nbsp;\u0648&nbsp;<a href=\"https:\/\/maktabkhooneh.org\/course\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-%D9%81%D8%B1%D9%85%D9%88%D9%84-%D8%AA%D9%88%D8%A7%D8%A8%D8%B9-%D9%BE%DB%8C%D8%B4%D8%B1%D9%81%D8%AA%D9%87-%D8%A7%DA%A9%D8%B3%D9%84-mk2121\/\">\u0622\u0645\u0648\u0632\u0634 \u0641\u0631\u0645\u0648\u0644 \u0646\u0648\u06cc\u0633\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a>&nbsp;\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u06a9\u0645\u0644 \u0628\u062d\u062b \u0641\u0648\u0642 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0633\u0644\u0648\u0644\u200c\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc \u062e\u0627\u0635\u06cc \u062f\u0627\u0631\u0646\u062f \u0627\u0632 \u062a\u0627\u0628\u0639 AVERAGEIF \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f. \u0627\u06af\u0631 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0647\u0645\u06cc\u0634\u06af\u06cc \u0628\u0631\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0628\u0627\u0634\u06cc\u062f\u060c \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f \u0639\u0627\u0644\u06cc \u0627\u06cc\u0646 \u0641\u0631\u0645\u0648\u0644 \u0622\u06af\u0627\u0647 \u0647\u0633\u062a\u06cc\u062f. \u062f\u0631 \u062a\u0627\u0628\u0639 AVERAGEIF \u062f\u0631 \u0627\u06a9\u0633\u0644\u060c \u0645\u062c\u0645\u0648\u0639 \u0647\u0645\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u06af\u0631\u0641\u062a\u0647 \u0648 \u0628\u0631 \u062a\u0639\u062f\u0627\u062f \u0622\u0646\u200c\u0647\u0627 \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f. \u0627\u0645\u0627 \u06af\u0627\u0647\u06cc \u0645\u0648\u0642\u0639\u06cc\u062a\u06cc \u067e\u06cc\u0634 \u0645\u06cc\u200c\u0622\u06cc\u062f \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a \u062a\u0639\u062f\u0627\u062f\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":30606,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36,38],"tags":[],"class_list":["post-30601","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-management-training-articles","category-how-to-learn-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/30601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/comments?post=30601"}],"version-history":[{"count":3,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/30601\/revisions"}],"predecessor-version":[{"id":66141,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/posts\/30601\/revisions\/66141"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media\/30606"}],"wp:attachment":[{"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/media?parent=30601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/categories?post=30601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maktabkhooneh.org\/mag\/wp-json\/wp\/v2\/tags?post=30601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}