Total only the visible rows
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
The Orders sheet is already filtered to Europe. In E22, use a formula to total only the visible Amount values.
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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 |
A passing output
Autosheet in Excel · Opus 5.5E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Pass criteria
All must be met, checked automatically.E22is 10,245E22uses a formula- The filter on
A1:H21stays - Rows 3, 5, 8, 10, 12, 14, 16, 18 and 20 are hidden
Passed 22
Autosheet in Excel Opus 5.5 · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Excel GPT-6 Astra · Low
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Sheets Opus 5.5 · Medium
E22=SUBTOTAL(109, E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Excel Sonnet 5.5 · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Claude in Excel Opus 5.5 · High
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Excel Haiku 5.5 · High
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Claude in Sheets Opus 5.5 · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Claude Code + Sheets MCP Opus 5.5 · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Excel GPT-6.1 Sol · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
E22=SUBTOTAL(109, E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
ChatGPT + Autosheet MCP GPT-6 · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Sheets Haiku 5.5 · High
E22=SUBTOTAL(109, E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
ChatGPT in Excel GPT-6 Astra · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Claude in Excel Haiku 5.5 · High
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Claude in Sheets Haiku 5.5 · High
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Autosheet in Excel GPT-6 Luna · High
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Copilot in Excel Auto
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10,245 |
ChatGPT + Drive MCP GPT-6 · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
ChatGPT in Excel GPT-6 Luna · High
E22=SUBTOTAL(9,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
Gemini in Sheets Auto
E22=SUBTOTAL(109, E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
ChatGPT in Sheets GPT-6 Astra · Medium
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |
ChatGPT in Sheets GPT-6 Luna · High
E22=SUBTOTAL(109,E2:E21)
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total |
| 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 | ||
| 9 | O-1008 | Europe | 2026-05-19 | Q2 | 860 | 17100 | ||
| 10 | O-1009 | Asia | 2026-06-02 | Q2 | 575 | 10950 | ||
| 11 | O-1010 | Europe | 2026-06-21 | Q2 | 930 | 18400 | ||
| 12 | O-1011 | South America | 2026-07-08 | Q3 | 680 | 12750 | ||
| 13 | O-1012 | Europe | 2026-07-23 | Q3 | 1100 | 21900 | ||
| 14 | O-1013 | North America | 2026-08-14 | Q3 | 790 | 15200 | ||
| 15 | O-1014 | Europe | 2026-09-05 | Q3 | 640 | 13100 | ||
| 16 | O-1015 | Asia | 2026-09-28 | Q3 | 1020 | 20500 | ||
| 17 | O-1016 | Europe | 2026-10-11 | Q4 | 880 | 17600 | ||
| 18 | O-1017 | North America | 2026-10-29 | Q4 | 560 | 10800 | ||
| 19 | O-1018 | Europe | 2026-11-13 | Q4 | 1350 | 26700 | ||
| 20 | O-1019 | Asia | 2026-11-27 | Q4 | 470 | 9200 | ||
| 21 | O-1020 | Europe | 2026-12-15 | Q4 | 995 | 19850 | ||
| 22 | 10245 |