{"id":9701,"date":"2023-03-09T12:20:00","date_gmt":"2023-03-09T11:20:00","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=9701"},"modified":"2023-03-09T10:54:37","modified_gmt":"2023-03-09T09:54:37","slug":"darabteli-vagy-darabha","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/","title":{"rendered":"DARABTELI vagy DARABHA"},"content":{"rendered":"\n

DARABTELI vagy DARABHA a helyes ford\u00edt\u00e1s? Az angol COUNTIF f\u00fcggv\u00e9nyt a magyarban sok\u00e1ig DARABTELI n\u00e9ven futott, de magyar Office 365-ben v\u00e9gre (2023 m\u00e1rcius) \u00e1tnevezte DARABHA f\u00fcggv\u00e9nynek:<\/p>\n\n\n\n

\"A<\/a><\/figure>\n\n\n\n

DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja<\/h2>\n\n\n\n

A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. P\u00e9ld\u00e1ul sz\u00e1mokn\u00e1l h\u00e1ny \u00e9rt\u00e9k nagyobb, mint 100, sz\u00f6vegekn\u00e9l valamilyen egyez\u00e9s vagy sz\u00f6vegtartalom (pl. Budapest\/vid\u00e9k eset\u00e9n h\u00e1ny adatn\u00e1l szerepel a vid\u00e9k). <\/p>\n\n\n\n

Az angol „COUNTIF” elnevez\u00e9s a „count” (sz\u00e1mol) \u00e9s az „if” (ha) szavak \u00f6sszet\u00e9tel\u00e9b\u0151l sz\u00e1rmazik. Hiszen ‘SZ\u00c1MOLD meg a cell\u00e1kat, HA teljes\u00fcl egy felt\u00e9tel (pl. az \u00e9rt\u00e9ke nagyobb mint 100)’<\/p>\n\n\n\n

A magyar nyelv\u0171 Excel verzi\u00f3kban a DARABTELI elnevez\u00e9s egy t\u00e9ves ford\u00edt\u00e1s eredm\u00e9nyek\u00e9nt DARABTELI lett. \u00c1ll\u00edt\u00f3lag a \u201cTELJESEN megegyezik\u201d alapj\u00e1n.<\/p>\n\n\n\n

A SZUMHA, \u00c1TLAGHA f\u00fcggv\u00e9nyeket azonban m\u00e1r az elej\u00e9t\u0151l ‘helyesen’ ford\u00edtott\u00e1k. Illetve mikor az Excel 2010-ben megjelentek a t\u00f6bb felt\u00e9telt is kezel\u0151 …HAT\u00d6BB v\u00e9g\u0171 f\u00fcggv\u00e9nyek, akkor a SZUMHAT\u00d6BB, \u00c1TLAGHAT\u00d6BB mellett DARABHAT\u00d6BB lett a f\u00fcggv\u00e9ny neve. Ha szeretn\u00e9l t\u00f6bbet tudni a k\u00fcl\u00f6nb\u00f6z\u0151 adatok megsz\u00e1mol\u00e1s\u00e1r\u00f3l, akkor olvasd el a DARAB f\u00fcggv\u00e9nyek haszn\u00e1lata cikkemet<\/a>.<\/p>\n\n\n\n

DARABTELI DARABHA \u00e1tnevez\u00e9s<\/h2>\n\n\n\n

A Microsoft t\u00f6rekv\u00e9se, hogy a helyi, \u00edgy a magyar Excel verzi\u00f3kban a f\u00fcggv\u00e9nyek elnevez\u00e9se szakszer\u0171 legyen, \u00e9s megk\u00f6nny\u00edtse a felhaszn\u00e1l\u00f3k sz\u00e1m\u00e1ra a f\u00fcggv\u00e9nyek meg\u00e9rt\u00e9s\u00e9t \u00e9s haszn\u00e1lat\u00e1t. A DARABHA elnevez\u00e9s v\u00e9gre hasonl\u00edt az eredeti logik\u00e1ra.<\/p>\n\n\n\n

A f\u00fcggv\u00e9ny fel\u00e9p\u00edt\u00e9se v\u00e1ltozatlan: el\u0151sz\u00f6r add meg azt a tartom\u00e1nyt, amelyben az \u00e9rt\u00e9keket figyeled\/sz\u00e1molod, majd mag\u00e1t a felt\u00e9telt. P\u00e9ld\u00e1ul:<\/p>\n\n\n\n

=DARABTELI(A2:A20;\u201df\u00e9rfi\u201d) helyett =DARABHA(A2:A20;\u201df\u00e9rfi\u201d)

=DARABTELI(C:D;”>100″) helyett =DARABHA(C:D;”>100″)<\/p>\n\n\n\n

A DARABTELI f\u00fcggv\u00e9nyt el\u0151szeretettel k\u00e9rdezik az informatika \u00e9retts\u00e9gin, itt tal\u00e1lod egy kor\u00e1bbi feladat<\/a> megold\u00e1s\u00e1t.<\/p>\n\n\n\n

T\u00f6bb inf\u00f3 az Excel f\u00fcggv\u00e9nyekr\u0151l<\/h2>\n\n\n\n

Ha \u00e9rdekelnek az Excel f\u00fcggv\u00e9nyek, itt tal\u00e1lsz tov\u00e1bbi hasznos inf\u00f3kat:<\/p>\n\n\n\n

SZUM vagy DARAB? Melyik mutat\u00f3sz\u00e1mhoz melyik f\u00fcggv\u00e9nyt v\u00e1laszd?<\/a><\/p>\n\n\n\n

30 Excel f\u00fcggv\u00e9ny, amit mindenkinek tudni \u00e9rdemes<\/a><\/p>\n\n\n\n

Leggyakoribb Excel f\u00fcggv\u00e9nyek, magyarul \u00e9s angolul<\/a><\/p>\n\n\n\n

Ha szorgalmas vagy \u00e9s szeretsz k\u00f6nyvb\u0151l tanulni, szeretn\u00e9l hasznos tippeket, billenty\u0171kombin\u00e1ci\u00f3kat \u00e9s f\u00fcggv\u00e9nyeket tanulni, akkor rendeld meg az Excel Kezd\u0151 & Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong>.<\/p>\n\n\n\n

Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online\u00a0csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>! Ha egy\u00e9nileg szeretn\u00e9l tanulni vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk\u00a0egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong>.<\/p>\n\n\n\n

Vagy gyere a VIP Klubba, ahol hasonl\u00f3 \u00e9rdekes megold\u00e1sokat tal\u00e1lsz<\/strong>, \u00e9s Te is b\u00e1rmikor k\u00e9rdezhetsz \u2013 \u00edgy egy biztos h\u00e1tt\u00e9rrel a saj\u00e1t temp\u00f3dban haladhatsz: Excel VIP Klub<\/a><\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9701","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"\nDARABTELI vagy DARABHA - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. 2023-t\u00f3l jav\u00edtja a Microsot az elenevez\u00e9st.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DARABTELI vagy DARABHA - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. 2023-t\u00f3l jav\u00edtja a Microsot az elenevez\u00e9st.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-09T11:20:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/DARABHA-DARABTELI_Excel.jpg\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"DARABTELI vagy DARABHA\",\"datePublished\":\"2023-03-09T11:20:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/\"},\"wordCount\":560,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/DARABHA-DARABTELI_Excel.jpg\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/\",\"name\":\"DARABTELI vagy DARABHA - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/DARABHA-DARABTELI_Excel.jpg\",\"datePublished\":\"2023-03-09T11:20:00+00:00\",\"description\":\"A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. 2023-t\u00f3l jav\u00edtja a Microsot az elenevez\u00e9st.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/DARABHA-DARABTELI_Excel.jpg\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2023\\\/03\\\/DARABHA-DARABTELI_Excel.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/darabteli-vagy-darabha\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DARABTELI vagy DARABHA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\\\/\\\/exceltitok.hu\\\/\",\"https:\\\/\\\/www.facebook.com\\\/bernadett.koros\"],\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/sos-excel\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DARABTELI vagy DARABHA - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. 2023-t\u00f3l jav\u00edtja a Microsot az elenevez\u00e9st.","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:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/","og_locale":"hu_HU","og_type":"article","og_title":"DARABTELI vagy DARABHA - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. 2023-t\u00f3l jav\u00edtja a Microsot az elenevez\u00e9st.","og_url":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2023-03-09T11:20:00+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/DARABHA-DARABTELI_Excel.jpg","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"DARABTELI vagy DARABHA","datePublished":"2023-03-09T11:20:00+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/"},"wordCount":560,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/DARABHA-DARABTELI_Excel.jpg","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/","url":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/","name":"DARABTELI vagy DARABHA - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/DARABHA-DARABTELI_Excel.jpg","datePublished":"2023-03-09T11:20:00+00:00","description":"A DARABTELI vagy DARABHA (COUNTIF) f\u00fcggv\u00e9ny c\u00e9lja egy bizonyos felt\u00e9telnek megfelel\u0151 \u00e9rt\u00e9kek megsz\u00e1mol\u00e1sa. 2023-t\u00f3l jav\u00edtja a Microsot az elenevez\u00e9st.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/DARABHA-DARABTELI_Excel.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2023\/03\/DARABHA-DARABTELI_Excel.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/darabteli-vagy-darabha\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"DARABTELI vagy DARABHA"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=9701"}],"version-history":[{"count":2,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9701\/revisions"}],"predecessor-version":[{"id":9704,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9701\/revisions\/9704"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}