{"id":6644,"date":"2011-04-02T00:33:42","date_gmt":"2011-04-01T21:33:42","guid":{"rendered":"http:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring.html"},"modified":"2011-04-02T00:33:42","modified_gmt":"2011-04-01T21:33:42","slug":"conditional-sum-cu-cautare-in-substring","status":"publish","type":"post","link":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/","title":{"rendered":"Conditional sum cu cautare in substring"},"content":{"rendered":"<p>Deci nu stiu ce m-a apucat dar cand ma apuc de ceva vreau sa duc pana la capat. N-am crezut ca pot sa-mi pierd atata timp cu excelul, in conditiile in care as putea sa calculez manual ceea ce vreau, dar ma ambitionez sa invat :P Banuiesc ca e un lucru bun sa stii cat mai multe, nu?<\/p>\n<p>Iata ceea ce nu reusesc. <\/p>\n<p>Se da tabelul de mai jos, presupunem ca am niste invitati si ii culc pe fiecare pe unde apuc, pe la prieteni, in cort, in rulota, in vagon sau mai stiu eu unde. <em>(e doar un exemplu, da?)<\/em><\/p>\n<p><a href=\"http:\/\/www.criserb.com\/blog\/poze\/Conditional-sum-cu-cautare-in-subsir_50E\/excel1.jpg\" data-lbwps-width=\"403\" data-lbwps-height=\"343\" data-lbwps-srcsmall=\"https:\/\/www.criserb.com\/blog\/poze\/Conditional-sum-cu-cautare-in-subsir_50E\/excel1.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-bottom: 0px; border-left: 0px; margin: 0px 1px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px\" title=\"excel1\" border=\"0\" alt=\"excel1\" src=\"http:\/\/www.criserb.com\/blog\/poze\/Conditional-sum-cu-cautare-in-subsir_50E\/excel1_thumb.jpg\" width=\"403\" height=\"343\" \/><\/a><\/p>\n<p><!--more--><\/p>\n<p>As vrea sa stiu cati prieteni sunt cazati in &quot;casa&quot;. Pentru asta am nevoie de o suma, suma persoanelor de pe coloana B cu conditia sa fie cazati in &quot;casa&quot;. Clar e vorba de o <strong>conditional sum<\/strong> pe care stiu sa o fac. Ceea ce nu stiu sa fac, este sa obtin aceasta suma cu cautare in string, <em>(sau substring?!?!)<\/em>. Dupa cum vedeti in coloana A am &quot;casa&quot; in diferite contexte&#8230; <\/p>\n<p>Daca imi poate da si mie cineva o mana de ajutor as putea sa dorm si eu linistit. Multumesc :)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Deci nu stiu ce m-a apucat dar cand ma apuc de ceva vreau sa duc pana la capat. N-am crezut ca pot sa-mi pierd atata timp cu excelul, in conditiile in care as putea sa calculez manual ceea ce vreau, dar ma ambitionez sa invat :P Banuiesc ca e un lucru bun sa stii cat&hellip;<\/p>\n","protected":false},"author":3,"featured_media":18893,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[44],"tags":[1946,1944,1947],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Conditional sum cu cautare in substring<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"criserb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/\"},\"author\":{\"name\":\"criserb\",\"@id\":\"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5\"},\"headline\":\"Conditional sum cu cautare in substring\",\"datePublished\":\"2011-04-01T21:33:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/\"},\"wordCount\":203,\"commentCount\":7,\"publisher\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5\"},\"image\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg\",\"keywords\":[\"Conditional Sum\",\"Excel\",\"Substr\"],\"articleSection\":[\"utile\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/\",\"url\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/\",\"name\":\"Conditional sum cu cautare in substring\",\"isPartOf\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg\",\"datePublished\":\"2011-04-01T21:33:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage\",\"url\":\"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg\",\"contentUrl\":\"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg\",\"width\":\"403\",\"height\":\"343\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.criserb.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conditional sum cu cautare in substring\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.criserb.com\/blog\/#website\",\"url\":\"https:\/\/www.criserb.com\/blog\/\",\"name\":\"criserb.com\",\"description\":\"Nimic ce merita citit :)\",\"publisher\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.criserb.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5\",\"name\":\"criserb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/fdb6cca710f39545f0c4b5b936c390b4?s=96&d=monsterid&r=pg\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/fdb6cca710f39545f0c4b5b936c390b4?s=96&d=monsterid&r=pg\",\"caption\":\"criserb\"},\"logo\":{\"@id\":\"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/www.criserb.com\"],\"url\":\"https:\/\/www.criserb.com\/blog\/author\/criserb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conditional sum cu cautare in substring","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/","twitter_misc":{"Written by":"criserb","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#article","isPartOf":{"@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/"},"author":{"name":"criserb","@id":"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5"},"headline":"Conditional sum cu cautare in substring","datePublished":"2011-04-01T21:33:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/"},"wordCount":203,"commentCount":7,"publisher":{"@id":"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5"},"image":{"@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage"},"thumbnailUrl":"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg","keywords":["Conditional Sum","Excel","Substr"],"articleSection":["utile"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/","url":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/","name":"Conditional sum cu cautare in substring","isPartOf":{"@id":"https:\/\/www.criserb.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage"},"image":{"@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage"},"thumbnailUrl":"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg","datePublished":"2011-04-01T21:33:42+00:00","breadcrumb":{"@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#primaryimage","url":"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg","contentUrl":"https:\/\/www.criserb.com\/blog\/poze\/2012\/06\/excel1_thumb1.jpg","width":"403","height":"343"},{"@type":"BreadcrumbList","@id":"https:\/\/www.criserb.com\/blog\/conditional-sum-cu-cautare-in-substring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.criserb.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Conditional sum cu cautare in substring"}]},{"@type":"WebSite","@id":"https:\/\/www.criserb.com\/blog\/#website","url":"https:\/\/www.criserb.com\/blog\/","name":"criserb.com","description":"Nimic ce merita citit :)","publisher":{"@id":"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.criserb.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/8df5199bda4e628c32a10f318d8602b5","name":"criserb","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/fdb6cca710f39545f0c4b5b936c390b4?s=96&d=monsterid&r=pg","contentUrl":"http:\/\/0.gravatar.com\/avatar\/fdb6cca710f39545f0c4b5b936c390b4?s=96&d=monsterid&r=pg","caption":"criserb"},"logo":{"@id":"https:\/\/www.criserb.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/www.criserb.com"],"url":"https:\/\/www.criserb.com\/blog\/author\/criserb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/posts\/6644"}],"collection":[{"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/comments?post=6644"}],"version-history":[{"count":0,"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/posts\/6644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/media\/18893"}],"wp:attachment":[{"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/media?parent=6644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/categories?post=6644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.criserb.com\/blog\/wp-json\/wp\/v2\/tags?post=6644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}