{"id":24,"date":"2026-02-04T23:58:30","date_gmt":"2026-02-04T21:58:30","guid":{"rendered":"https:\/\/timofeistoljarov.wordpress.com\/?page_id=24"},"modified":"2026-02-04T23:58:30","modified_gmt":"2026-02-04T21:58:30","slug":"pohifunktisoonid","status":"publish","type":"page","link":"https:\/\/timofeistoljarov.eu\/wp\/ai-tooriistade-tulemuslik-kasutamine\/exeli-funktsioonide-nimekiri\/pohifunktisoonid\/","title":{"rendered":"P\u00f5hifunktisoonid"},"content":{"rendered":"\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>SUM<\/strong><\/td><td>Liidab k\u00f5ik valemisse sisestatud arvud v\u00f5i lahtrivahemiku numbrid. Sobib kogusummade, kogumahtude ja arvutusk\u00e4ikude tegemiseks.<\/td><\/tr><tr><td><strong>AVERAGE<\/strong><\/td><td>Arvutab valitud arvude keskmise (aritmeetilise keskv\u00e4\u00e4rtuse). Kasulik tulemuste, hinnangute ja m\u00f5\u00f5tmiste anal\u00fc\u00fcsimisel.<\/td><\/tr><tr><td><strong>MIN<\/strong><\/td><td>Tagastab k\u00f5ige v\u00e4iksema v\u00e4\u00e4rtuse antud lahtrivahemikust. Kasutatakse minimaalse hinna, madalaima punktisumma jt leidmiseks.<\/td><\/tr><tr><td><strong>MAX<\/strong><\/td><td>Tagastab suurima v\u00e4\u00e4rtuse vahemikust. Kasulik maksimumtulemuste ja tippv\u00e4\u00e4rtuste leidmiseks.<\/td><\/tr><tr><td><strong>COUNT<\/strong><\/td><td>Loendab ainult lahtrid, mis sisaldavad numbreid. Ei loenda t\u00fchje ega teksti sisaldavaid lahtrid.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>SUM<\/strong><\/td><td>\u0421\u043a\u043b\u0430\u0434\u044b\u0432\u0430\u0435\u0442 \u0432\u0441\u0435 \u0447\u0438\u0441\u043b\u0430 \u0432 \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0435 \u0438\u043b\u0438 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442\u0430\u0445. \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u043f\u043e\u0434\u0441\u0447\u0451\u0442\u0430 \u0438\u0442\u043e\u0433\u043e\u0432 \u0438 \u0441\u0443\u043c\u043c.<\/td><\/tr><tr><td><strong>AVERAGE<\/strong><\/td><td>\u0412\u044b\u0447\u0438\u0441\u043b\u044f\u0435\u0442 \u0441\u0440\u0435\u0434\u043d\u0435\u0435 \u0430\u0440\u0438\u0444\u043c\u0435\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0432\u044b\u0431\u0440\u0430\u043d\u043d\u044b\u0445 \u0447\u0438\u0441\u0435\u043b.<\/td><\/tr><tr><td><strong>MIN<\/strong><\/td><td>\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0438\u0437 \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0430.<\/td><\/tr><tr><td><strong>MAX<\/strong><\/td><td>\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043c\u0430\u043a\u0441\u0438\u043c\u0430\u043b\u044c\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0438\u0437 \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0430.<\/td><\/tr><tr><td><strong>COUNT<\/strong><\/td><td>\u0421\u0447\u0438\u0442\u0430\u0435\u0442 \u0442\u043e\u043b\u044c\u043a\u043e \u044f\u0447\u0435\u0439\u043a\u0438, \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0449\u0438\u0435 \u0447\u0438\u0441\u043b\u0430. \u041d\u0435 \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u0435\u0442 \u0442\u0435\u043a\u0441\u0442 \u0438 \u043f\u0443\u0441\u0442\u044b\u0435 \u044f\u0447\u0435\u0439\u043a\u0438.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>SUM Liidab k\u00f5ik valemisse sisestatud arvud v\u00f5i lahtrivahemiku numbrid. Sobib kogusummade, kogumahtude ja arvutusk\u00e4ikude tegemiseks. AVERAGE Arvutab valitud arvude keskmise (aritmeetilise keskv\u00e4\u00e4rtuse). Kasulik tulemuste, hinnangute ja m\u00f5\u00f5tmiste anal\u00fc\u00fcsimisel. MIN Tagastab k\u00f5ige v\u00e4iksema v\u00e4\u00e4rtuse antud lahtrivahemikust. Kasutatakse minimaalse hinna, madalaima punktisumma jt leidmiseks. MAX Tagastab suurima v\u00e4\u00e4rtuse vahemikust. Kasulik maksimumtulemuste ja tippv\u00e4\u00e4rtuste leidmiseks. COUNT Loendab ainult [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":14,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-24","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":0,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages\/24\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/pages\/14"}],"wp:attachment":[{"href":"https:\/\/timofeistoljarov.eu\/wp\/wp-json\/wp\/v2\/media?parent=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}