Create and use a named range
FormulasEasyDeterministic scoringLatest run
Passed by 11 of 12 products on their best model. Failed: ChatGPT in Sheets.
Prompt
Create a named range called MonthlySales for B2:B5, then use that name in a formula in B6 to total the sales.
Starting spreadsheet
Sheet1| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
A passing output
Autosheet in Excel · Opus 5.5B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Pass criteria
All must be met, checked automatically.B6is 5,600B6uses a formula that refers toMonthlySales- A named range
MonthlySalesexists
Passed 20
Autosheet in Excel Opus 5.5 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Autosheet in Excel GPT-6 Astra · Low
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Autosheet in Sheets Opus 5.5 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Autosheet in Excel Sonnet 5.5 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Claude in Excel Opus 5.5 · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Autosheet in Excel Haiku 5.5 · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Claude in Sheets Opus 5.5 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Claude Code + Sheets MCP Opus 5.5 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Autosheet in Excel GPT-6.1 Sol · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
ChatGPT + Autosheet MCP GPT-6 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Autosheet in Sheets Haiku 5.5 · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
ChatGPT in Excel GPT-6 Astra · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Claude in Excel Haiku 5.5 · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Claude in Sheets Haiku 5.5 · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | Total | 5600 |
Autosheet in Excel GPT-6 Luna · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Copilot in Excel Auto
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
ChatGPT + Drive MCP GPT-6 · Medium
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
ChatGPT in Excel GPT-6 Luna · High
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Gemini in Sheets Auto
B6=SUM(MonthlySales)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Failed 2
ChatGPT in Sheets GPT-6 Astra · Medium
B6=SUM(B2:B5)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Why it failed: B6's formula doesn't use MonthlySales. No named range MonthlySales.
ChatGPT in Sheets GPT-6 Luna · High
B6=SUM(B2:B5)
| A | B | |
|---|---|---|
| 1 | Month | Sales |
| 2 | Jan | 1200 |
| 3 | Feb | 1500 |
| 4 | Mar | 1800 |
| 5 | Apr | 1100 |
| 6 | 5600 |
Why it failed: B6's formula doesn't use MonthlySales. No named range MonthlySales.