WiseAICo
Work & Career · Lesson 4 of 6

Check a spreadsheet formula.

About 10 minutesWorks in any free AI chat appAll-Access lesson

Find out why a total looks wrong, get the fixed formula, and understand what it does before you trust it.

All-Access lesson. Members get every lesson like this one for $19 a month. You’re seeing a preview while membership opens.
New to words like prompt, follow-up or @Name? They’re all explained in AI Basics, Lesson 1. It’s free and takes about 10 minutes.
i.

See what you’ll make

A total that looked wrong, explained in plain words and fixed.

The problem
Column D has monthly costs in rows 2 to 9.
Cell D10 has: =SUM(D2:D8)

I expected $4,950 but got $4,320.
The explanation

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.

ii.

Watch or read

  1. Describe the layout

    Say what’s in each column and which rows have data. The AI can’t see your spreadsheet.

  2. Copy the formula exactly

    Click the cell, then copy the formula from the bar above the grid.

  3. Say what you expected and what you got

    The gap between the two numbers is often the clue.

  4. Test the fix on numbers you can check

    Try it on two or three cells you can add up in your head.

Excel or Google Sheets? Say which one. Most formulas work in both, but some don’t.
iii.

Copy the prompt

Copy this and fill in the gold words from your spreadsheet.

I’m using Excel or Google Sheets. My layout: what’s in each column and which rows have data In cell the cell, like D10 I have this formula: paste the formula I expected the number you expected but got the number you got. Explain in plain words what the formula does and what’s wrong, then give me the fixed formula.
iv.

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.

What the AI was given
Column B has monthly sales, rows 2 to 13
(January to December).
Cell B14 has: =SUM(B2:B13)/10
I want the average month.
The AI’s answer

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.

What to send backYou 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?
v.

Try it with your own details

Before you paste anything

  • Describe the layout instead of pasting real figures if they’re confidential
Nothing you type here leaves this page.
vi.

What’s next

Finished?
Mark the lesson done to save your progress.

Done. That’s lesson 4 of Work & Career.