video1.0<iframe src="https://www.loom.com/embed/d873b8f7071742908e7baa73ffdb3e05" frameborder="0" width="1920" height="1440" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>14401920Loomhttps://www.loom.com14401920https://cdn.loom.com/sessions/thumbnails/d873b8f7071742908e7baa73ffdb3e05-771585835cba557c.gif523.86In 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!