# E1 | perplexity/sonar-pro | 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:

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

It sums all values in **column B** where the matching cell in **column A** equals **"Paid"**[1](https://support.microsoft.com/en-us/excel/functions/sumif-function).

If you want, I can also give you the same formula for a specific row range like `A2:A100` and `B2:B100`?
