{"id":10106,"date":"2026-06-08T17:37:13","date_gmt":"2026-06-08T15:37:13","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=10106"},"modified":"2026-06-11T00:01:08","modified_gmt":"2026-06-10T22:01:08","slug":"szummazas-helyesen","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/","title":{"rendered":"Szumm\u00e1z\u00e1s helyesen"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Sokat \u00edrtam m\u00e1r arr\u00f3l, hogy egy egszer\u0171 SZUM f\u00fcggv\u00e9ny is okozhat galib\u00e1kat:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/\" type=\"link\" id=\"https:\/\/sosexcel.com\/exceltippek\/rossz-helyre-teszed-a-szummat\/\" target=\"_blank\" rel=\"noreferrer noopener\">Rossz helyre teszed a Szumm\u00e1t<\/a><\/li>\n\n\n\n<li>\u00daj oszlop vagy sor eset\u00e9n <a href=\"https:\/\/sosexcel.com\/exceltippek\/nem-szamol-jol-a-szumma\/\" type=\"link\" id=\"https:\/\/sosexcel.com\/exceltippek\/nem-szamol-jol-a-szumma\/\" target=\"_blank\" rel=\"noreferrer noopener\">nem sz\u00e1mol j\u00f3l a szumma<\/a><\/li>\n\n\n\n<li>Vagy bizonyos esetekben <a href=\"https:\/\/sosexcel.com\/exceltippek\/nem-reagal-a-szumma\/\" type=\"link\" id=\"https:\/\/sosexcel.com\/exceltippek\/nem-reagal-a-szumma\/\" target=\"_blank\" rel=\"noreferrer noopener\">nem &#8216;reag\u00e1l&#8217; az AutoSzum gomb<\/a><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Ebben a vide\u00f3ban megmutatom, hogy haszn\u00e1ld helyesen a Szumm\u00e1t! Fontos, hogy mindig abba a cell\u00e1ba \u00edrd a szumm\u00e1t, ahol az eredm\u00e9nyt l\u00e1tni szeretn\u00e9d. Az Excel automatikusan felismeri a k\u00e9plet felett vagy el\u0151tt szerepl\u0151 sz\u00e1mokat, \u00e9s automatikusan \u00f6sszes\u00edti. <\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/ZXnkelWbeK0?si=QqrJXkTNARRL7pfz\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<h2 class=\"wp-block-heading\">Kiv\u00e9tel vagy Szumma tr\u00fckk <\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Van azonban egy kiv\u00e9tel, pont ezek a t\u00edpus\u00fa t\u00e1bl\u00e1zatok, amikor a t\u00e1bl\u00e1zat alj\u00e1n \u00e9s a v\u00e9g\u00e9n is szeretn\u00e9l \u00f6sszes\u00edteni. Erre ugyanis van egy tr\u00fckk: jel\u00f6ld ki az \u00f6sszes adatot, plusz m\u00e9g azt az \u00fcres sort \u00e9s oszlopot, ahov\u00e1 a szumm\u00e1t szeretn\u00e9d megkapni. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"339\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-1024x339.png\" alt=\"\" class=\"wp-image-10107\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-1024x339.png 1024w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-300x99.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-768x254.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-1536x508.png 1536w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum.png 1542w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Ugyanis, hogyha \u00edgy nyomod meg a szumm\u00e1t, akkor minden cell\u00e1ba egyb\u0151l beker\u00fcl a megfelel\u0151 \u00f6sszes\u00edtett \u00e9rt\u00e9k.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Szumma billenty\u0171kombin\u00e1ci\u00f3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A szumm\u00e1z\u00e1snak is van gyorsgombja, ez pedig az <strong>Alt =<\/strong> (egyenl\u0151s\u00e9gjel), azaz <strong>Alt + Shift + 7<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Mac-en: Ctrl Shift T (mint Total)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha sokat haszn\u00e1lod a SZUM f\u00fcggv\u00e9nyt, akkor \u00e9rdemes megjegyezni. Ugyan\u00fagy m\u0171k\u00f6dik, mint az AutoSzum gomb, azaz ha \u00fcres cell\u00e1ba illeszted, akkor megkeresi \u00e9s kijel\u00f6li a legk\u00f6zelebbi felfele, vagy &#8211; ha ott nincs sz\u00e1m -, akkor balra l\u00e9v\u0151 sz\u00e1mokat, \u00e9s villog\u00f3 kerettel kijel\u00f6li, amin m\u00e9g tudsz m\u00f3dos\u00edtani.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ha szeretn\u00e9l fejl\u0151dni az Excelben<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ha szeretn\u00e9d ilyen \u00e9s <strong>hasonl\u00f3 p\u00e9ld\u00e1kon <\/strong>begyakorolni az Excel alapjait, akkor aj\u00e1nlom a Kezd\u0151 Excel feladatok p\u00e9ldat\u00e1rat, amelyben 29 kidolgozott \u00e9s tov\u00e1bbi 34 extra feladatot tal\u00e1lsz: <a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-nagyagyu<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha a kezd\u0151 szintr\u0151l eg\u00e9szen halad\u00f3ig szeretn\u00e9l eljutni, \u00e9s ehhez szeretn\u00e9l \u00e9l\u0151 t\u00e1mogat\u00e1st is, akkor gyere hozz\u00e1nk tanfolyamra! A<strong> 9 alkalmas online \u00e9l\u0151 oktat\u00e1son<\/strong> hasonl\u00f3, egyre halad\u00f3bb feladatokkal dolgozunk: <a href=\"https:\/\/exceltitok.hu\/kezdo-halado\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/kezdo-halado\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">M\u00e9g t\u00f6bb hasznos <a href=\"https:\/\/exceltitok.hu\/gyb55\/\" type=\"link\" id=\"https:\/\/exceltitok.hu\/gyb55\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel billenty\u0171kombin\u00e1ci\u00f3<\/a>, amivel tud\u00e1sszintt\u0151l f\u00fcggetlen\u00fcl hetente \u00f3r\u00e1kat sp\u00f3rolhatsz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udcd7 Excel&nbsp;<strong>tank\u00f6nyv&nbsp;<\/strong>\u2013 gyakorlati p\u00e9ld\u00e1k, \u00e9rthet\u0151 magyar\u00e1zatok, \u00e9s a v\u00e9g\u00e9n 5 oldalnyi gyorsbillenty\u0171-lista:&nbsp;<a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-tankonyv\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udcca K\u00fcl\u00f6n Google T\u00e1bl\u00e1zatok k\u00f6nyv:&nbsp;<a href=\"https:\/\/exceltitok.hu\/google-tablazatok-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/google-tablazatok-tankonyv\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u2728 VIP Klub, ahol k\u00f6z\u00f6sen tanulunk \u2013 es egyb\u0151l hozz\u00e1f\u00e9rsz a kor\u00e1bbi 20+ alkalom felv\u00e9tel\u00e9hez is. T\u00f6bbek k\u00f6z\u00f6tt&nbsp;<strong>3 \u00f3r\u00e1nyi gyorsbillenty\u0171 gyakorl\u00e1s<\/strong>hoz, valamint egy PDF-ben let\u00f6ltheted az 55 napos kih\u00edv\u00e1s anyag\u00e1t:&nbsp;<a href=\"https:\/\/excelklub.hu\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/excelklub.hu\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sokat \u00edrtam m\u00e1r arr\u00f3l, hogy egy egszer\u0171 SZUM f\u00fcggv\u00e9ny is okozhat galib\u00e1kat: Ebben a vide\u00f3ban megmutatom, hogy haszn\u00e1ld helyesen a Szumm\u00e1t! Fontos, hogy mindig abba a cell\u00e1ba \u00edrd a szumm\u00e1t, ahol az eredm\u00e9nyt l\u00e1tni szeretn\u00e9d. Az Excel automatikusan felismeri a k\u00e9plet felett vagy el\u0151tt szerepl\u0151 sz\u00e1mokat, \u00e9s automatikusan \u00f6sszes\u00edti. Kiv\u00e9tel vagy Szumma tr\u00fckk Van azonban [&hellip;]<\/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":"","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":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","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-10106","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Szumm\u00e1z\u00e1s helyesen - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/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:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Szumm\u00e1z\u00e1s helyesen - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Sokat \u00edrtam m\u00e1r arr\u00f3l, hogy egy egszer\u0171 SZUM f\u00fcggv\u00e9ny is okozhat galib\u00e1kat: Ebben a vide\u00f3ban megmutatom, hogy haszn\u00e1ld helyesen a Szumm\u00e1t! Fontos, hogy mindig abba a cell\u00e1ba \u00edrd a szumm\u00e1t, ahol az eredm\u00e9nyt l\u00e1tni szeretn\u00e9d. Az Excel automatikusan felismeri a k\u00e9plet felett vagy el\u0151tt szerepl\u0151 sz\u00e1mokat, \u00e9s automatikusan \u00f6sszes\u00edti. Kiv\u00e9tel vagy Szumma tr\u00fckk Van azonban [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/\" \/>\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=\"2026-06-08T15:37:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-10T22:01:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1542\" \/>\n\t<meta property=\"og:image:height\" content=\"510\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Szumm\u00e1z\u00e1s helyesen\",\"datePublished\":\"2026-06-08T15:37:13+00:00\",\"dateModified\":\"2026-06-10T22:01:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/\"},\"wordCount\":466,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Autoszum-1024x339.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/\",\"name\":\"Szumm\u00e1z\u00e1s helyesen - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Autoszum-1024x339.png\",\"datePublished\":\"2026-06-08T15:37:13+00:00\",\"dateModified\":\"2026-06-10T22:01:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Autoszum.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Autoszum.png\",\"width\":1542,\"height\":510},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/szummazas-helyesen\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Szumm\u00e1z\u00e1s helyesen\"}]},{\"@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":"Szumm\u00e1z\u00e1s helyesen - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","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\/szummazas-helyesen\/","og_locale":"hu_HU","og_type":"article","og_title":"Szumm\u00e1z\u00e1s helyesen - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Sokat \u00edrtam m\u00e1r arr\u00f3l, hogy egy egszer\u0171 SZUM f\u00fcggv\u00e9ny is okozhat galib\u00e1kat: Ebben a vide\u00f3ban megmutatom, hogy haszn\u00e1ld helyesen a Szumm\u00e1t! Fontos, hogy mindig abba a cell\u00e1ba \u00edrd a szumm\u00e1t, ahol az eredm\u00e9nyt l\u00e1tni szeretn\u00e9d. Az Excel automatikusan felismeri a k\u00e9plet felett vagy el\u0151tt szerepl\u0151 sz\u00e1mokat, \u00e9s automatikusan \u00f6sszes\u00edti. Kiv\u00e9tel vagy Szumma tr\u00fckk Van azonban [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2026-06-08T15:37:13+00:00","article_modified_time":"2026-06-10T22:01:08+00:00","og_image":[{"width":1542,"height":510,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Szumm\u00e1z\u00e1s helyesen","datePublished":"2026-06-08T15:37:13+00:00","dateModified":"2026-06-10T22:01:08+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/"},"wordCount":466,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-1024x339.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/","url":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/","name":"Szumm\u00e1z\u00e1s helyesen - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum-1024x339.png","datePublished":"2026-06-08T15:37:13+00:00","dateModified":"2026-06-10T22:01:08+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Autoszum.png","width":1542,"height":510},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/szummazas-helyesen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Szumm\u00e1z\u00e1s helyesen"}]},{"@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\/10106","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=10106"}],"version-history":[{"count":1,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10106\/revisions"}],"predecessor-version":[{"id":10108,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10106\/revisions\/10108"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=10106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=10106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=10106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}