# E1 | openai/gpt-5.4-mini | 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:

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

This adds all values in column B where the corresponding cell in column A is exactly `Paid`.

If you want, I can also give you the equivalent formula for a specific sheet range like `A2:A100`.
