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

## Prompt

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

## Response

`=SUMIF(A:A,"Paid",B:B)` sums all values in column B where the corresponding cell in column A is `"Paid"`. Use the same formula in both Excel and Google Sheets [SUMIF function](https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a6532d6d).
