Sumifs

The Sumifs function is a feature that allows you to sum the values in a range based on one or more criteria.

See it in Action

Requirements

Data

• Target Data

  • Data Range: Identify the data range where you want to apply the function.

• Criterion: You can set multiple criteria to refine your sums. For each criterion, provide details in the following format:

  • Column: Specify the column in your data range that the criterion applies to.

  • Operator: Choose an operation that defines the relationship between the data and your criterion. Options include "==", "!=", ">=", "<=", ">", "<" for direct comparisons; "empty" or "not empty" for checking cell content; and "include" or "not include" for finding text within cells.

  • Value: Enter the value to be compared against the data in the specified column.

• Column to Sum: Choose the column with the numbers to sum. It must be different from the criteria columns but in the same range.

Fill empty cells with

• Keep Empty: Leave cells that are empty as is, without adding any text.

• Forward Fill: Copy the value from the nearest non-empty cell above into empty cells before adding the specified letters or text.

• Backward Fill: Copy the value from the nearest non-empty cell below into empty cells before adding the specified letters or text.

• -: Fill empty cells with a letter "-".

• 0: Fill empty cells with a letter "0".

• Custom: Allows for a custom value or text to be inserted into empty cells prior to adding the specified letters.

Result Destination

Specify the starting cell where the results will be placed.