ADDIF function in Excel with examples

The SUMIF function in Excel is incredibly useful for conditional summing. Instead of adding up all numbers in a range, it allows you to sum only those values that meet specific criteria. Let’s dive into how it works:

1. Syntax: The SUMIF function has three arguments:

   • Range (required): The cells to be evaluated based on the criteria.
   • Criteria (required): The condition that must be met (e.g., a number, text, date, or logical expression).
   • Sum_range (optional): The range to sum if the condition is met. If omitted, the function sums the original range.

2. Basic Example: Suppose you have a table with products (column A), regions (column B), and sales amounts (column C). To get the total sales for a specific region (e.g., “North”), use this formula:

   =SUMIF(B2:B10, "North", C2:C10)
   

3. Variations:

   • Sum if greater than or less than: To sum values greater than 5, use:

     =SUMIF(B2:B25, ">5")
     

   • Sum if equal to: To sum values equal to a specific text or number, adjust the criteria accordingly.
   • Sum if not equal to: Use the “<>” operator to sum values that don’t match a certain condition.
   • Sum if blank or not blank: For blank cells, use an empty string (“”) as the criteria.

Remember, once you’ve mastered SUMIF, similar functions like SUMIFS, COUNTIF, and AVERAGEIF will be a breeze!