# Excel AI: Free AI for Excel Formulas, Analysis & Charts

- URL: https://betteranalyst.com/excel-ai
- Author: Better Analyst

### Add amounts for one department

Sum column A where column B is Marketing.

| Row | A: Amount | B: Department |
| - | - | - |
| 2 | 120 | Marketing |
| 3 | 80 | Sales |
| 4 | 200 | Marketing |

Formula

```
=SUMIF(B2:B4,"Marketing",A2:A4)
```

**Expected result:** 320

The two Marketing amounts are 120 and 200. SUMIF adds only those matching rows.

[Learn SUMIF and try the formula tool](https://betteranalyst.com/excel/sumif-function)