{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/d873b8f7071742908e7baa73ffdb3e05\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/d873b8f7071742908e7baa73ffdb3e05-771585835cba557c.gif","duration":523.86,"title":"Comparing Files Using SUMIF - Excel","description":"In this video, I walk you through how to compare two files in Excel using the SUMIF function, especially when dealing with duplicate entries. I demonstrate how to extract unique values and sum amounts effectively, ensuring you can analyze your data accurately. I also touch on using VLOOKUP for additional context. Please make sure to follow along and try these techniques in your own files!"}