{"id":291,"date":"2012-07-06T10:50:37","date_gmt":"2012-07-06T09:50:37","guid":{"rendered":"http:\/\/www.matjazev.net\/blog\/?p=291"},"modified":"2012-07-06T10:50:59","modified_gmt":"2012-07-06T09:50:59","slug":"sestevanje-samo-negativnihpozitivnih-vrednosti","status":"publish","type":"post","link":"https:\/\/www.matjazev.net\/blog\/2012\/07\/06\/sestevanje-samo-negativnihpozitivnih-vrednosti\/","title":{"rendered":"Se\u0161tevanje samo negativnih ~ pozitivnih vrednosti&#8230;"},"content":{"rendered":"<h3>Re\u0161itev ponuja funkcija SUMIF, ki jo lahko uporabite vedno, kadar \u017eelite se\u0161tevati glede na nek kriterij&#8230;<\/h3>\n<p><pre>=SUMIF(obmo\u010dje1; kriterij; obmo\u010dje2)<\/pre><br \/>\nKot vidite sprejme funkcija tri parametre. Prvi parameter je obmo\u010dje nad katerim \u017eelite testirati  kriterij, drugi parameter je kriterij, tretji parameter pa je seveda obmo\u010dje, ki ga \u017eelite se\u0161teti.<\/p>\n<p><a href=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/11\/sumif.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-296\" title=\"sumif\" src=\"http:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/11\/sumif.gif\" alt=\"\" width=\"409\" height=\"169\" srcset=\"https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/11\/sumif.gif 409w, https:\/\/www.matjazev.net\/blog\/wp-content\/uploads\/2010\/11\/sumif-300x123.gif 300w\" sizes=\"(max-width: 409px) 100vw, 409px\" \/><\/a><\/p>\n<p><em><strong>PS:<\/strong> Bodite pozorni na tretji primer, kjer sta obmo\u010dji razli\u010dni, saj Celje i\u0161\u010demo po prvem, se\u0161tevamo pa po drugem!<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Re\u0161itev ponuja funkcija SUMIF, ki jo lahko uporabite vedno, kadar \u017eelite se\u0161tevati glede na nek kriterij&#8230; =SUMIF(obmo\u010dje1; kriterij; obmo\u010dje2) Kot vidite sprejme funkcija tri parametre. Prvi parameter je obmo\u010dje nad katerim \u017eelite testirati kriterij, drugi parameter je kriterij, tretji parameter pa je seveda obmo\u010dje, ki ga \u017eelite se\u0161teti. PS: Bodite pozorni na tretji primer, kjer &hellip; <a href=\"https:\/\/www.matjazev.net\/blog\/2012\/07\/06\/sestevanje-samo-negativnihpozitivnih-vrednosti\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Se\u0161tevanje samo negativnih ~ pozitivnih vrednosti&#8230;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,3],"tags":[14,31,61,30],"_links":{"self":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/291"}],"collection":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/comments?post=291"}],"version-history":[{"count":15,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":1169,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/posts\/291\/revisions\/1169"}],"wp:attachment":[{"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/media?parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/categories?post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matjazev.net\/blog\/wp-json\/wp\/v2\/tags?post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}