Sum a metric across monthly tabs
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
On the Summary tab, use formulas in B2:B3 to total each metric's Amount across the Jan, Feb, and Mar tabs.
Jan
Starting sheet| A | B | |
|---|---|---|
| 1 | Metric | Amount |
| 2 | Total Sales | 42000 |
| 3 | Total Cost | 31000 |
Feb
Starting sheet| A | B | |
|---|---|---|
| 1 | Metric | Amount |
| 2 | Total Sales | 38000 |
| 3 | Total Cost | 29000 |
Mar
Starting sheet| A | B | |
|---|---|---|
| 1 | Metric | Amount |
| 2 | Total Sales | 51000 |
| 3 | Total Cost | 33000 |
Summary
Starting sheet| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | |
| 3 | Total Cost |
A passing output
Autosheet in Excel · Opus 5.5B2=SUMIF(Jan!$A:$A,$A2,Jan!$B:$B)+SUMIF(Feb!$A:$A,$A2,Feb!$B:$B)+SUMIF(Mar!$A:$A,$A2,Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Pass criteria
All must be met, checked automatically.Summary!B2is 131,000 andSummary!B3is 93,000Summary!B2:B3use formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
B2=SUMIF(Jan!$A:$A,$A2,Jan!$B:$B)+SUMIF(Feb!$A:$A,$A2,Feb!$B:$B)+SUMIF(Mar!$A:$A,$A2,Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Excel GPT-6 Astra · Low
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Sheets Opus 5.5 · Medium
B2=SUMIF(Jan!$A:$A, $A2, Jan!$B:$B) + SUMIF(Feb!$A:$A, $A2, Feb!$B:$B) + SUMIF(Mar!$A:$A, $A2, Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Excel Sonnet 5.5 · Medium
B2=SUMIF(Jan!$A$2:$A$3,$A2,Jan!$B$2:$B$3)+SUMIF(Feb!$A$2:$A$3,$A2,Feb!$B$2:$B$3)+SUMIF(Mar!$A$2:$A$3,$A2,Mar!$B$2:$B$3)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Claude in Excel Opus 5.5 · High
B2=SUMIF(Jan!$A:$A,$A2,Jan!$B:$B)+SUMIF(Feb!$A:$A,$A2,Feb!$B:$B)+SUMIF(Mar!$A:$A,$A2,Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Excel Haiku 5.5 · High
B2=SUMIF(Jan!$A:$A,$A2,Jan!$B:$B)+SUMIF(Feb!$A:$A,$A2,Feb!$B:$B)+SUMIF(Mar!$A:$A,$A2,Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Claude in Sheets Opus 5.5 · Medium
B2=SUMIF(Jan!$A$2:$A1000,$A2,Jan!$B$2:$B1000)+SUMIF(Feb!$A$2:$A1000,$A2,Feb!$B$2:$B1000)+SUMIF(Mar!$A$2:$A1000,$A2,Mar!$B$2:$B1000)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Claude Code + Sheets MCP Opus 5.5 · Medium
B2=SUMIF(Jan!$A:$A,$A2,Jan!$B:$B)+SUMIF(Feb!$A:$A,$A2,Feb!$B:$B)+SUMIF(Mar!$A:$A,$A2,Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Excel GPT-6.1 Sol · Medium
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
B2=SUMIF(Jan!$A:$A, $A2, Jan!$B:$B) + SUMIF(Feb!$A:$A, $A2, Feb!$B:$B) + SUMIF(Mar!$A:$A, $A2, Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
ChatGPT + Autosheet MCP GPT-6 · Medium
B2=SUMIF(Jan!$A:$A,$A2,Jan!$B:$B)+SUMIF(Feb!$A:$A,$A2,Feb!$B:$B)+SUMIF(Mar!$A:$A,$A2,Mar!$B:$B)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Sheets Haiku 5.5 · High
B2=Jan!B2+Feb!B2+Mar!B2
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
ChatGPT in Excel GPT-6 Astra · Medium
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Claude in Excel Haiku 5.5 · High
B2=Jan!B2+Feb!B2+Mar!B2
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Claude in Sheets Haiku 5.5 · High
B2=Jan!B2+Feb!B2+Mar!B2
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Autosheet in Excel GPT-6 Luna · High
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Copilot in Excel Auto
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131,000 |
| 3 | Total Cost | 93,000 |
ChatGPT + Drive MCP GPT-6 · Medium
B2=SUM(SUMIF(Jan!A:A,A2,Jan!B:B),SUMIF(Feb!A:A,A2,Feb!B:B),SUMIF(Mar!A:A,A2,Mar!B:B))
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
ChatGPT in Excel GPT-6 Luna · High
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
Gemini in Sheets Auto
B2=Jan!B2+Feb!B2+Mar!B2
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
ChatGPT in Sheets GPT-6 Astra · Medium
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |
ChatGPT in Sheets GPT-6 Luna · High
B2=SUM(Jan!B2,Feb!B2,Mar!B2)
| A | B | |
|---|---|---|
| 1 | Metric | Total |
| 2 | Total Sales | 131000 |
| 3 | Total Cost | 93000 |