SUMIF Formula in MS Excel

 The SUMIF formula in Excel is used to add up values that meet certain criteria. Here are the steps to use the SUMIF formula:

1. Open the Excel sheet where you want to use the SUMIF formula.

2. Select the cell where you want to display the result.

3. Type the following formula:

scss
=SUMIF(range,criteria,[sum_range])

Here, "range" refers to the range of cells that you want to check for the criteria, "criteria" refers to the condition that you want to apply, and "sum_range" refers to the range of cells that you want to add up (optional).

4. Replace the "range" and "criteria" values with the actual range and criteria that you want to use. For example, if you want to add up all the values in the range A1:A10 that are greater than 5, your formula would be:
5. if you want to give criteria then in the formula give the address of the cell as below e.g. in formula below the criteria will be in cell "E6".

less
=SUMIF(A1:A10,">5")
=SUMIF(A1:A10,">" &E6)

5. If you want to add up values in a different range than the range that you're checking for criteria, add that range as the third argument in the formula. For example, if you want to add up values in the range B1:B10, your formula would be:

less
=SUMIF(A1:A10,">5",B1:B10)

6. Press Enter to complete the formula. The result should be displayed in the selected cell.

That's it! You have now successfully used the SUMIF formula in Excel.

Alternatively, you can use the Function Wizard to help you build your SUMIF formula. Here's how: Select the cell where you want the result to appear. Click on the formula bar or fx bar at the top of the screen. Type "=SUMIF(" followed by the range of cells you want to evaluate. Click on the "fx" button next to the formula bar to open the Function Wizard. In the Function Wizard, select the SUMIF function from the list of functions or type it in the search bar. Follow the prompts to enter the criterion or condition you want to apply and the range of cells you want to sum. Click OK to insert the formula into the formula bar and press Enter to calculate the result. Remember to adjust the range of cells and criterion or condition to suit your specific needs.