Advanced Formulas (SUMIFS, COUNTIFS)✡️ | Notion

1. SUMIFS

The SUMIFS function calculates the sum of a range based on multiple conditions.

Syntax

sum_range: The range you want to add up.
criteria_range1: The range that contains the values you want to evaluate.
criteria1: The condition for the criteria_range1.
[criteria_range2, criteria2]: Optional. More conditions if needed.

Examples

Basic Example:

Multiple Conditions:

Copy of Copy of Copy of class Car def init(self, brand, model) self.brand = brand self.model = model (43).png

2. COUNTIFS

The COUNTIFS function counts the number of cells that meet multiple conditions. It’s similar to SUMIFS but counts rather than adds values.

Syntax

criteria_range1: The range to check for the first condition.
criteria1: The condition for criteria_range1.
[criteria_range2, criteria2]: Optional. Additional conditions if needed.