Using Excel's SUMIF() Function

 To use Excel's SUMIF() function, which adds up the numbers in a range that meet a specified condition, follow these steps:

Open Excel: Launch Excel and open the worksheet containing the data you want to analyze.

Select a cell: Click on the cell where you want the result of the SUMIF() function to appear.

Type the function: In the selected cell, type =SUMIF( to start the function.

Specify the range: After typing =SUMIF(, specify the range of cells you want to evaluate. This is the range where you want Excel to sum the numbers.

Enter the criteria: After specifying the range, enter the criteria that you want Excel to use for summing. This can be a specific value, expression, or text string. For example, if you want to sum the numbers in the range B1:B10 where the corresponding cells in the range A1:A10 contain the value "Apples", you would enter "Apples".

Specify the sum range (optional): If the range to sum is different from the range used for the criteria, you can specify it as the third argument of the function. Otherwise, Excel assumes the sum range is the same as the criteria range.

Close the function: Close the parentheses ) to complete the function.

Press Enter: After closing the parentheses, press Enter to execute the function. The result will appear in the selected cell, showing the sum of numbers in the specified range that meet the specified condition.

Here's an example:

Suppose you have a list of fruit names in cells A1:A10, and corresponding quantities in cells B1:B10. You want to sum the quantities for "Apples".

=SUMIF(A1:A10, "Apples", B1:B10)

This formula will sum the quantities in the range B1:B10 where the corresponding cells in the range A1:A10 contain the value "Apples", and display the sum in the selected cell. If you omit the third argument, SUMIF will sum the cells in the criteria range (A1:A10 in this case).