In this Excel video tutorial, we gonna see how to Compare Lists in Excel to Find Repeated Values and find Missing Information with an Easy Method using the SUMIF formula or sumif function in Excel.

I have two sales reports in Excel, I need to compare whether there is duplicate information between these two sheets. I cannot leave the reports with duplicate information, as this could interfere with the math of revenue.

I can use several criteria to define whether or not the same order is repeated. I can use the order ID the customer name, the product name, the quantity, the value, etc. I can use many conditions and a formula that can help me, is the count If or countif formula in Excel.

The countif function counts not all the values you selected within a range but only the values that meet a certain criteria. Only the values equal to the specified criteria.

The countif function in Excel can help us to automate tasks and I also can help us to make analysis through a large data set basically we can take a deluge of the data and slice and dice using the count if function in Excel

the countif function as the name suggests it can count the number of cells that has a given criteria, or in other words the count is function can count not everything but only the things that met with the criteria that we specify.

#JopaExcel #Dashboard #Excel