All AutosheetBench tasks

Sum revenue for one region and quarter

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Using a formula, put total Revenue for Europe in Q1 in J2.

Starting spreadsheet

Orders
ABCDEFGH
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q172014400
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

A passing output

Autosheet in Excel · Opus 5.5
Orders2 cells changed

J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalEurope Q1 Revenue
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • J2 is 49,800
  • J2 uses a formula

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed15s · 3¢
Orders2 cells changed

J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalEurope Q1 Revenue
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel GPT-6 Astra · Low

Passed4s · 3¢
Orders1 cell changed

J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Sheets Opus 5.5 · Medium

Passed12s · 2¢
Orders2 cells changed

J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalEurope Q1 Revenue
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel Sonnet 5.5 · Medium

Passed3s · 0.8¢
Orders1 cell changed

J2=SUMIFS(F2:F9,B2:B9,"Europe",D2:D9,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Excel Opus 5.5 · High

Passed8s · 6¢
Orders1 cell changed

J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel Haiku 5.5 · High

Passed6s · 0.1¢
Orders2 cells changed

J2=SUMIFS($F$2:$F$9,$B$2:$B$9,"Europe",$D$2:$D$9,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of TotalEurope Q1 Revenue
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Sheets Opus 5.5 · Medium

Passed14s · 5¢
Orders1 cell changed

J2=SUMIFS(F2:F1000,B2:B1000,"Europe",D2:D1000,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed23s · N/A
Orders1 cell changed

J2=SUMIFS(F2:F1000,B2:B1000,"Europe",D2:D1000,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel GPT-6.1 Sol · Medium

Passed6s · 1¢
Orders1 cell changed

J2=SUMIFS(F2:F9,B2:B9,"Europe",D2:D9,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed28s · N/A
Orders1 cell changed

J2=SUMIFS($F$2:$F$8, $B$2:$B$8, "Europe", $D$2:$D$8, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed24s · N/A
Orders1 cell changed

J2=SUMIFS($F$2:$F$8, $B$2:$B$8, "Europe", $D$2:$D$8, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Sheets Haiku 5.5 · High

Passed13s · 0.1¢
Orders1 cell changed

J2=SUMIFS(F:F, B:B, "Europe", D:D, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Excel GPT-6 Astra · Medium

Passed12s · 40¢
Orders1 cell changed

J2=SUMIFS(F2:F9,B2:B9,"Europe",D2:D9,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Excel Haiku 5.5 · High

Passed6s · 0.3¢
Orders1 cell changed

J2=SUMIFS($F$2:$F$8,$B$2:$B$8,"Europe",$D$2:$D$8,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Claude in Sheets Haiku 5.5 · High

Passed18s · 1¢
Orders1 cell changed

J2=SUMIFS($F$2:$F1000, $B$2:$B1000, "Europe", $D$2:$D1000, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Autosheet in Excel GPT-6 Luna · High

Passed5s · 0.1¢
Orders1 cell changed

J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Copilot in Excel Auto

Passed17s · N/A
Orders1 cell changed

J2=SUMIFS(F2:F8,B2:B8,"Europe",D2:D8,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049,800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT + Drive MCP GPT-6 · Medium

Passed22s · N/A
Orders1 cell changed

J2=SUMIFS(F2:F1000,B2:B1000,"Europe",D2:D1000,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Excel GPT-6 Luna · High

Passed12s · 0.4¢
Orders1 cell changed

J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

Gemini in Sheets Auto

Passed39s · N/A
Orders1 cell changed

J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Sheets GPT-6 Astra · Medium

Passed22s · 31¢
Orders1 cell changed

J2=SUMIFS(F2:F8,B2:B8,"Europe",D2:D8,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200

ChatGPT in Sheets GPT-6 Luna · High

Passed18s · 0.3¢
Orders1 cell changed

J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")

ABCDEFGHIJ
1Order IDRegionDateQuarterAmountRevenueCumulative Revenue% of Total
2O-1001Europe2026-01-08Q17201440049800
3O-1002North America2026-01-17Q14508250
4O-1003Europe2026-02-09Q198018900
5O-1004Asia2026-02-17Q161011200
6O-1005Europe2026-03-03Q154016500
7O-1006Europe2026-04-12Q2125024800
8O-1007North America2026-05-06Q23207200