Sum revenue for one region and quarter
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Using a formula, put total Revenue for Europe in Q1 in J2.
Starting spreadsheet
Orders| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | ||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
A passing output
Autosheet in Excel · Opus 5.5J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Europe Q1 Revenue | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Pass criteria
All must be met, checked automatically.J2is 49,800J2uses a formula
Passed 22
Autosheet in Excel Opus 5.5 · Medium
J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Europe Q1 Revenue | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Excel GPT-6 Astra · Low
J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Sheets Opus 5.5 · Medium
J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Europe Q1 Revenue | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Excel Sonnet 5.5 · Medium
J2=SUMIFS(F2:F9,B2:B9,"Europe",D2:D9,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Claude in Excel Opus 5.5 · High
J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Excel Haiku 5.5 · High
J2=SUMIFS($F$2:$F$9,$B$2:$B$9,"Europe",$D$2:$D$9,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Europe Q1 Revenue | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Claude in Sheets Opus 5.5 · Medium
J2=SUMIFS(F2:F1000,B2:B1000,"Europe",D2:D1000,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Claude Code + Sheets MCP Opus 5.5 · Medium
J2=SUMIFS(F2:F1000,B2:B1000,"Europe",D2:D1000,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Excel GPT-6.1 Sol · Medium
J2=SUMIFS(F2:F9,B2:B9,"Europe",D2:D9,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
J2=SUMIFS($F$2:$F$8, $B$2:$B$8, "Europe", $D$2:$D$8, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
ChatGPT + Autosheet MCP GPT-6 · Medium
J2=SUMIFS($F$2:$F$8, $B$2:$B$8, "Europe", $D$2:$D$8, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Sheets Haiku 5.5 · High
J2=SUMIFS(F:F, B:B, "Europe", D:D, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
ChatGPT in Excel GPT-6 Astra · Medium
J2=SUMIFS(F2:F9,B2:B9,"Europe",D2:D9,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Claude in Excel Haiku 5.5 · High
J2=SUMIFS($F$2:$F$8,$B$2:$B$8,"Europe",$D$2:$D$8,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Claude in Sheets Haiku 5.5 · High
J2=SUMIFS($F$2:$F1000, $B$2:$B1000, "Europe", $D$2:$D1000, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Autosheet in Excel GPT-6 Luna · High
J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Copilot in Excel Auto
J2=SUMIFS(F2:F8,B2:B8,"Europe",D2:D8,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49,800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
ChatGPT + Drive MCP GPT-6 · Medium
J2=SUMIFS(F2:F1000,B2:B1000,"Europe",D2:D1000,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
ChatGPT in Excel GPT-6 Luna · High
J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
Gemini in Sheets Auto
J2=SUMIFS(F2:F8, B2:B8, "Europe", D2:D8, "Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
ChatGPT in Sheets GPT-6 Astra · Medium
J2=SUMIFS(F2:F8,B2:B8,"Europe",D2:D8,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |
ChatGPT in Sheets GPT-6 Luna · High
J2=SUMIFS(F:F,B:B,"Europe",D:D,"Q1")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | ||
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 49800 | |||
| 3 | O-1002 | North America | 2026-01-17 | Q1 | 450 | 8250 | ||||
| 4 | O-1003 | Europe | 2026-02-09 | Q1 | 980 | 18900 | ||||
| 5 | O-1004 | Asia | 2026-02-17 | Q1 | 610 | 11200 | ||||
| 6 | O-1005 | Europe | 2026-03-03 | Q1 | 540 | 16500 | ||||
| 7 | O-1006 | Europe | 2026-04-12 | Q2 | 1250 | 24800 | ||||
| 8 | O-1007 | North America | 2026-05-06 | Q2 | 320 | 7200 |