Most Excel problems are not really formula problems. You know what you want — the total of one column where another column says something specific, the last value in a list that keeps growing, a lookup that should say “not found” instead of #N/A — and the gap is only that you cannot remember which function takes which arguments, or in which order.
Formula AI closes that gap in both directions. Describe the calculation and it writes the formula. Paste a formula somebody else wrote and it tells you what the thing actually does, argument by argument.
Write what you want in plain English — “sum column A where column B says Completed” — and get a working formula back, ready to paste into the cell.
Paste a formula you inherited and get it back in sentences: what each argument does, and which part is the one that will break when the sheet changes.
For the questions that are not one formula wide — why a range needs dollar signs, when INDEX/MATCH beats VLOOKUP, why a total is ignoring a column of numbers that are secretly text.
Five common asks, the formula each one produces, and what that formula returns against the sample sheet below. Every result here came out of the same engine that grades the exercises, rather than being written from memory.
| What you ask for | Formula | Result |
|---|---|---|
| Total the amounts where the status is Completed | =SUMIF(B2:B6,"Completed",A2:A6) | 470 |
| Count the scores above 5 | =COUNTIF(C2:C6,">5") | 4 |
| Average the completed amounts | =AVERAGEIF(B2:B6,"Completed",A2:A6) | 156.67 |
| Get the last amount in the column | =INDEX(A2:A6,COUNTA(A2:A6)) | 200 |
| Look something up, but say “not found” instead of #N/A | =IFERROR(VLOOKUP("Missing",B2:C6,2,FALSE),"not found") | not found |
| A | B | C | |
|---|---|---|---|
| 1 | Amount | Status | Score |
| 2 | 120 | Completed | 8 |
| 3 | 80 | Pending | 3 |
| 4 | 150 | Completed | 12 |
| 5 | 40 | Pending | 6 |
| 6 | 200 | Completed | 9 |
Generating formulas is part of Pro, but the reference page for every function above is free to read, and the first four tracks of exercises are free to solve in a real grid — no card, and no sign-up wall in front of the first one.