Have AI analyse spreadsheets and explain formulas

Attached is a spreadsheet with [content, e.g. invoices with date, amount and status], without names. My question: [question, e.g. What is the total of open invoices per month?]

1. First state the number of rows, the column names and how you read dates and amounts (date format DD.MM.YYYY, comma as decimal separator). If a column has empty or inconsistent values, say so before you calculate.
2. Calculate with the data analysis tool, not in your head. Give the result as a small table and a control total that can be checked against the file.
3. Give the formula I can use to recalculate this myself in Excel, for the [German or English] Excel version, with the column letters from my file, and explain it in two sentences.

Do not make any assumption silently: if it is unclear what counts (e.g. status “partly paid”), ask.

Pourquoi cela fonctionne : The control total and your own formula make calculation errors and misread dates visible before you pass the figure on.