{"id":22,"date":"2025-07-19T20:11:49","date_gmt":"2025-07-19T18:11:49","guid":{"rendered":"https:\/\/baza.kajodata.com\/?p=22"},"modified":"2025-07-27T21:00:52","modified_gmt":"2025-07-27T19:00:52","slug":"porownanie-z-wieksze-niz","status":"publish","type":"post","link":"https:\/\/baza.kajodata.com\/?p=22","title":{"rendered":"Por\u00f3wnanie z wi\u0119ksze ni\u017c"},"content":{"rendered":"\n<p>Korzystanie z COUNTIF czy COUNTIFS jest proste je\u015bli por\u00f3wnujemy na zasadzie &#8222;=&#8221; (czyli r\u00f3wne).<\/p>\n\n\n\n<p> A co je\u015bli chcemy por\u00f3wna\u0107 na zasadzie:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>mniejsze ni\u017c<\/li>\n\n\n\n<li>wi\u0119ksze ni\u017c <\/li>\n\n\n\n<li>mniejsze lub r\u00f3wne<\/li>\n\n\n\n<li>wi\u0119ksze lub r\u00f3wne<\/li>\n<\/ul>\n\n\n\n<p>Je\u017celi por\u00f3wnujemy w tym samym zakresie (np. wi\u0119ksze lub r\u00f3wne 90):<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>=COUNTIF(C5:C16,\">=90\")<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">=COUNTIF(C5:C16,&quot;&gt;=90&quot;)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>Je\u017celi por\u00f3wnujemy do innej kom\u00f3rki:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span role=\"button\" tabindex=\"0\" style=\"color:#d8dee9ff;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>=COUNTIF(C5:C16,\">\"&amp;A1)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #d8dee9ff\">=COUNTIF(C5:C16,&quot;&gt;&quot;&amp;A1)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Korzystanie z COUNTIF czy COUNTIFS jest proste je\u015bli por\u00f3wnujemy na zasadzie &#8222;=&#8221; (czyli r\u00f3wne). A co je\u015bli chcemy por\u00f3wna\u0107 na zasadzie: Je\u017celi por\u00f3wnujemy w tym samym zakresie (np. wi\u0119ksze lub r\u00f3wne 90): Je\u017celi por\u00f3wnujemy do innej kom\u00f3rki:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[7,16,12],"class_list":["post-22","post","type-post","status-publish","format-standard","hentry","category-excel","tag-excel","tag-pl","tag-tekst"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22"}],"version-history":[{"count":1,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":23,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions\/23"}],"wp:attachment":[{"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/baza.kajodata.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}