{"id":1733,"date":"2023-11-08T20:50:38","date_gmt":"2023-11-08T20:50:38","guid":{"rendered":"https:\/\/exceladvisor.org\/it\/somma-per-data\/"},"modified":"2023-12-10T06:20:20","modified_gmt":"2023-12-10T06:20:20","slug":"somma-per-data","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/it\/somma-per-data\/","title":{"rendered":"Come aggiungere valori in base a una data?"},"content":{"rendered":"<div class=\"excel-prima-del-contenuto\" id=\"excel-770772028\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Per utilizzare SOMMA.SE per aggiungere valori basati sulla data come criterio, puoi fare riferimento alla cella in cui hai la data oppure puoi inserire la data direttamente nella funzione. In SUMIFS hai l&#8217;argomento criterio e in quell&#8217;argomento; \u00e8 necessario specificare la data per la quale si desidera aggiungere i valori. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77816\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\" sizes=\"auto, \" srcset=\"\" alt=\"valori di somma basati sulle date\" width=\"451\" height=\"474\"><\/figure><\/div><p> In questo tutorial impareremo come utilizzare la funzione SOMMA.SE di Excel in una data.<\/p><h2 class=\"wp-block-heading\"> Utilizza SOMMA.SE per data in Excel<\/h2><ol type=\"1\"><li> Innanzitutto, inserisci <code>=SUMIF(<\/code> la cella in cui desideri la somma.<\/li><li> Successivamente, fare riferimento alla colonna della data, intervallo A2:A15.<\/li><li> Quindi, nell&#8217;argomento criteri, fai riferimento alla cella in cui hai la data.<\/li><li> Ora, nell&#8217;ultimo argomento, fai riferimento alla colonna della somma, intervallo B2:B15.<\/li><li> Alla fine, inserisci le parentesi di chiusura e premi Invio per ottenere il risultato. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77817\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-sumif-par-date-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-per-data-in-excel\" width=\"549\" height=\"465\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">=SUMIF(A2:A15,D4,B2:B15)<\/code><\/pre><p> Con la formula sopra, ottieni la somma per la data \u201c15-ott-2022\u201d nel risultato. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77818\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-somme-si-par-date-result1.png\" sizes=\"auto, \" srcset=\"\" alt=\"somma per data del risultato\" width=\"457\" height=\"447\"><\/figure><\/div><p> Puoi anche inserire la data nell&#8217;argomento della funzione come valore.<\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A15,\"15-Oct-2022\",B2:B15) =SUMIF(A2:A15,DATE(2022,10,15),B2:B15) =SUMIF(A2:A15,\"15-10-2022\",B2:B15)<\/code><\/pre><h2 class=\"wp-block-heading\"> SOMMA prima o dopo una data utilizzando SOMMA.SE<\/h2><p> Puoi anche utilizzare un operatore logico con la data da aggiungere prima o dopo una data specifica. Nell&#8217;esempio seguente, abbiamo un segno maggiore di insieme alla data. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77819\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-somme-avant-ou-apres-la-date.png\" sizes=\"auto, \" srcset=\"\" alt=\"somma prima o dopo la data\" width=\"683\" height=\"443\"><\/figure><\/div><p> Quando premi Invio restituisce 2028, che \u00e8 il totale della data 15 novembre 2022. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77820\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-sumif-date-resultat.png\" sizes=\"auto, \" srcset=\"\" alt=\"risultato-sumif-data\" width=\"453\" height=\"446\"><\/figure><\/div><p> Allo stesso modo, puoi utilizzare un operatore minore di (&lt;) per sommare in base a date inferiori alla data nella cella D4. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77821\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-sumif-avec-signe-inferieur.png\" sizes=\"auto, \" srcset=\"\" alt=\"somma-con-segno-inferiore\" width=\"369\" height=\"152\"><\/figure><\/div><p> Ecco alcuni altri operatori che puoi utilizzare:<\/p><ul><li> Diverso da &lt;&gt;<\/li><li> Maggiore o uguale a &gt;=<\/li><li> Minore e uguale a &lt;= <\/li><\/ul><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Ottieni il file Excel<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/dates-de-somme.xlsx\" rel=\"nofollow\">Scaricamento<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/it\/formule\/\">Elenco delle formule di Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Formule correlate <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/it\/somma-se-maggiore-di\/\">Somma maggiore dei valori utilizzando SOMMA.SE<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/sutive-non-uguali\/\">Somma di valori non uguali (SUMIFS) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/sumif-sumif-o-logica\/\">SOMMA.SE\/SOMMA.FS con logica OR in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/sumif-con-caratteri-jolly\/\">SOMMA.SE con caratteri jolly in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/it\/somma-di-valori-tra-due-date\/\">Intervallo di date SUMIFS (somma dei valori tra due array di date)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1733","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Come aggiungere valori in base a una data?<\/title>\n<meta name=\"description\" content=\"In questo tutorial impareremo come aggiungere valori in base a una data utilizzando SOMMA.SE e imparerai anche come\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/it\/somma-per-data\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Come aggiungere valori in base a una data?\" \/>\n<meta property=\"og:description\" content=\"In questo tutorial impareremo come aggiungere valori in base a una data utilizzando SOMMA.SE e imparerai anche come\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/it\/somma-per-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:20:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/\",\"name\":\"\u25b7 Come aggiungere valori in base a una data?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\",\"datePublished\":\"2023-11-08T20:50:38+00:00\",\"dateModified\":\"2023-12-10T06:20:20+00:00\",\"description\":\"In questo tutorial impareremo come aggiungere valori in base a una data utilizzando SOMMA.SE e imparerai anche come\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/it\/somma-per-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/it\/somma-per-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/exceladvisor.org\/it\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Come aggiungere valori in base a una data?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#website\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"name\":\"Excel Advisor\",\"description\":\"Tips, Tricks, and Time-Saving Hacks\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/it\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/it\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Come aggiungere valori in base a una data?","description":"In questo tutorial impareremo come aggiungere valori in base a una data utilizzando SOMMA.SE e imparerai anche come","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:\/\/exceladvisor.org\/it\/somma-per-data\/","og_locale":"it_IT","og_type":"article","og_title":"\u25b7 Come aggiungere valori in base a una data?","og_description":"In questo tutorial impareremo come aggiungere valori in base a una data utilizzando SOMMA.SE e imparerai anche come","og_url":"https:\/\/exceladvisor.org\/it\/somma-per-data\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:20:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo di lettura stimato":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/it\/somma-per-data\/","url":"https:\/\/exceladvisor.org\/it\/somma-per-data\/","name":"\u25b7 Come aggiungere valori in base a una data?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/it\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/it\/somma-per-data\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/somma-per-data\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png","datePublished":"2023-11-08T20:50:38+00:00","dateModified":"2023-12-10T06:20:20+00:00","description":"In questo tutorial impareremo come aggiungere valori in base a una data utilizzando SOMMA.SE e imparerai anche come","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/it\/somma-per-data\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/it\/somma-per-data\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/somma-per-data\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-des-valeurs-basees-sur-les-dates.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/it\/somma-per-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exceladvisor.org\/it\/"},{"@type":"ListItem","position":2,"name":"Come aggiungere valori in base a una data?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/it\/#website","url":"https:\/\/exceladvisor.org\/it\/","name":"Excel Advisor","description":"Tips, Tricks, and Time-Saving Hacks","publisher":{"@id":"https:\/\/exceladvisor.org\/it\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/it\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/it\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/it\/","logo":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/it\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/it\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/comments?post=1733"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1733\/revisions"}],"predecessor-version":[{"id":2297,"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/pages\/1733\/revisions\/2297"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/it\/wp-json\/wp\/v2\/media?parent=1733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}