Sumif Formula in MS Excel

 Sumif Formula in MS Excel

The SUMIF formula in MS Excel is used to sum the values in a range based on a specified criteria. It allows you to add up values in a range of cells that meet a certain condition.

The syntax of the SUMIF formula is as follows:

SUMIF(range, criteria, [sum_range])

Where:

• range: The range of cells that you want to apply the criteria to.
• criteria: The condition that must be met for a cell to be included in the sum.
• [sum_range]: Optional. The range of cells to be summed if the criteria are met. If this argument is omitted, the range argument is used as the sum range.

For example, if you have a table of data in the range A1:B10, with column A containing names and column B containing values, you can use the SUMIF formula to sum the values for a specific name:

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

This would return the sum of all values in the range B1:B10 that are associated with the name "John" in the range A1:A10.

Note: The SUMIF formula is often used in combination with the MATCH formula to look up the relative position of an item in a table.