Summary  
This chapter introduces conditional aggregation functions that compute filtered sums and counts by applying multiple criteria with built-in AND logic.  

General domain of usage  
Budgeting and expense tracking

### SUMIFS
`SUMIFS` reads left to right: first you tell it which column to add up, then you give it one or more condition pairs — a column to check and a value to match. Every pair you add narrows the result further. The function only adds a row's value when every condition is satisfied simultaneously, which makes it **AND** logic by default.
```
=SUMIFS(sum_range; criteria_range1; criteria1; criteria_range2; criteria2; ...)

=SUMIFS(D:D, B:B, "Dining")
```

When using comparison operators as criteria, wrap the entire condition in quotes: ">100", "<=50", "<>0". Writing >100 without quotes causes an error.

Note

### COUNTIFS
`COUNTIFS` shares the exact same structure as `SUMIFS` with one important difference: there is no sum range. You start immediately with condition pairs, because the function is not adding values — it is simply counting how many rows satisfy the criteria. This makes it slightly shorter to write, and it works on any column type, including text columns that `SUMIFS` would not be able to add.
```
=COUNTIFS(range1; criteria1; [range2; criteria2]; ...)

=COUNTIFS(G:G; "Variable")
```

Both functions apply **AND** logic across multiple conditions — every condition must be satisfied for a row to be included. There is no built-in **OR** mode; for **OR** behaviour you need to sum two separate SUMIFS results.

Learn Excel the fun way — step by step, you'll go from basic data handling to building charts and dashboards that actually make sense. You'll learn how to organize messy data, use formulas with confidence, and turn numbers into clear insights.


Messy spreadsheets turn into clean, structured data. Tables, sorting, filtering, and smart input rules help keep everything accurate and easy to work with.

Raw data becomes clear and readable. Formatting, alignment, and conditional highlights make important insights stand out instantly.

Numbers start working for you. Formulas, functions, and logical conditions handle calculations, automate tasks, and solve real problems.

Data turns into visuals that tell a story. Charts, sparklines, and design improvements make information easy to understand at a glance.

Big datasets become simple summaries. PivotTables, interactive controls, and dashboards bring everything together into clear, dynamic insights.

Conditional Aggregation

SUMIFS

COUNTIFS