# E1 | mistralai/mistral-small-2603 | run 1

## Prompt

Write a spreadsheet formula (Excel/Sheets) that sums all values in column B where the matching cell in column A equals 'Paid'.

## Response

Use this formula in Excel or Google Sheets:

```excel
=SUMIF(A:A, "Paid", B:B)
```

If you need case-insensitive matching, use:

```excel
=SUMIFS(B:B, A:A, "Paid")
```

Google Sheets users can also use QUERY for flexibility:

```excel
=SUM(QUERY(A:B, "select B where A = 'Paid'"))
```
