See what you’ll make
A total that looked wrong, explained in plain words and fixed.
Column D has monthly costs in rows 2 to 9. Cell D10 has: =SUM(D2:D8) I expected $4,950 but got $4,320.
What’s wrong: your formula adds rows 2 to 8, so it misses row 9.
The fix: =SUM(D2:D9)
Check it: the difference, $630, should match the number in D9.
Watch or read
- Describe the layout
Say what’s in each column and which rows have data. The AI can’t see your spreadsheet.
- Copy the formula exactly
Click the cell, then copy the formula from the bar above the grid.
- Say what you expected and what you got
The gap between the two numbers is often the clue.
- Test the fix on numbers you can check
Try it on two or three cells you can add up in your head.
The walkthrough video is on its way.
The Read tab covers everything in it.Copy the prompt
Copy this and fill in the gold words from your spreadsheet.
Explain each part of the formula, one piece at a time.Is there a simpler formula that does the same thing?Check the answer
The AI can make mistakes that sound right. Tick off each check before you use the answer.
Practice: find the mistake
Here’s an answer the AI could give. One line says something that isn’t true or wasn’t asked for. Click the line you think is wrong.
Column B has monthly sales, rows 2 to 13 (January to December). Cell B14 has: =SUM(B2:B13)/10 I want the average month.
Your formula divides by 10, but there are 12 months.
A simpler fix is =AVERAGE(B2:B13).
AVERAGE counts any blank month as zero.
Test it: add three months by hand and compare.
You said AVERAGE counts blank cells as zero. I think it skips them. Which is it, and what should I do if a month is blank?
Try it with your own details
Before you paste anything
- Describe the layout instead of pasting real figures if they’re confidential
What’s next
Finished?
Mark the lesson done to save your progress.