In this Excel video tutorial, we are going to learn how to do the sum function in Excel. SumIf formula in Excel.

Within my experience, this Excel formula is widely used in job interviews and Excel tests for the job market.

The sumif function in Excel is one of the most important functions in Excel this formula is one of the most important formulas in Excel the sumif function in Excel helps us to add up all the values in the range if these values match the criteria we specify.

Unlike the SUM function, the SUMIF formula in Excel does not sum all values. The SUMIF formula will sum only a few specific values.

A practical example is the following:

Let's say you have a sales spreadsheet in Excel and, with your report table, you have information such as date, customer name, product purchased, unit value, total value and the name of the salesperson responsible for the sale.

Rather than adding up the entire column of total sold and thus getting the Grand Total sold, you need to know the total that each salesperson sold.

That way, instead of using the SUM function, you can use the SUMIF function to help you solve this problem in Excel. Then, the SUMIF function sums only the values that match the criteria we specify.


#JopaExcel #Dashboard #Excel