Fix numbers stored as text
Data operationsEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
The Total cell currently shows an error when it sums the amounts, can you fix ?
Starting spreadsheet
Import| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | #DIV/0! |
A passing output
Autosheet in Excel · Opus 5.5B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Pass criteria
All must be met, checked automatically.B2:B7hold the expected valuesB7uses a formula
Passed 18
Autosheet in Excel Opus 5.5 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Autosheet in Sheets Opus 5.5 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Autosheet in Excel Sonnet 5.5 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6590.5 |
Claude in Excel Opus 5.5 · High
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Claude in Sheets Opus 5.5 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Claude Code + Sheets MCP Opus 5.5 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Autosheet in Excel GPT-6.1 Sol · Medium
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
ChatGPT + Autosheet MCP GPT-6 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Autosheet in Sheets Haiku 5.5 · High
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
ChatGPT in Excel GPT-6 Astra · Medium
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Claude in Excel Haiku 5.5 · High
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Claude in Sheets Haiku 5.5 · High
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
Copilot in Excel Auto
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
ChatGPT + Drive MCP GPT-6 · Medium
B7=IF(OR(ISTEXT(B2),ISTEXT(B3),ISTEXT(B4),ISTEXT(B5),ISTEXT(B6)),1/0,SUM(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1,250.00 |
| 3 | Beacon | 980.50 |
| 4 | Comet | 2,100.00 |
| 5 | Delta | 760.00 |
| 6 | Echo | 1,500.00 |
| 7 | Total | 6,590.50 |
ChatGPT in Excel GPT-6 Luna · High
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Gemini in Sheets Auto
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
ChatGPT in Sheets GPT-6 Astra · Medium
B7=SUM(B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Failed 4
Autosheet in Excel GPT-6 Astra · Low
B7=SUMPRODUCT(--B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.
Autosheet in Excel Haiku 5.5 · High
B7=SUMPRODUCT(VALUE(B2:B6))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.
Autosheet in Excel GPT-6 Luna · High
B7=SUMPRODUCT(NUMBERVALUE(B2:B6,".",","))
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.
ChatGPT in Sheets GPT-6 Luna · High
B7=SUMPRODUCT(--B2:B6)
| A | B | |
|---|---|---|
| 1 | Product | Amount |
| 2 | Atlas | 1250 |
| 3 | Beacon | 980.5 |
| 4 | Comet | 2100 |
| 5 | Delta | 760 |
| 6 | Echo | 1500 |
| 7 | Total | 6590.5 |
Why it failed: 5 cells are wrong, such as B2: "1250" instead of 1,250.