Count the orders above an amount
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Using a formula, put the number of orders with an Amount above $500 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=COUNTIF(E2:E8,">500")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Orders > $500 | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 5 | |||
| 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 |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.J2is 5J2uses a formula
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed13s · 3¢
J2=COUNTIF(E2:E8,">500")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Orders > $500 | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 5 | |||
| 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
Passed5s · 3¢
J2=COUNTIF(Orders!E2:E9,">500")
| 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 | 5 | |||
| 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
Passed10s · 2¢
J2=COUNTIF(E2:E8, ">500")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Orders > $500 | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 5 | |||
| 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
Passed3s · 0.8¢
J2=COUNTIF(E2:E9,">500")
| 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 | 5 | |||
| 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
Passed10s · 6¢
J2=COUNTIF(E:E,">500")
| 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 | 5 | |||
| 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
Passed5s · 0.1¢
J2=COUNTIF(E:E,">500")
| 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 | 5 | |||
| 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
Passed18s · 6¢
J2=COUNTIF(E2:E1000,">500")
| 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 | 5 | |||
| 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
Passed17s · N/A
J2=COUNTIF(E2:E1000, ">500")
| 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 | 5 | |||
| 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
Passed5s · 0.9¢
J2=COUNTIF(E2:E9,">500")
| 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 | 5 | |||
| 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
Passed29s · N/A
J2=COUNTIF(E2:E8, ">500")
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order ID | Region | Date | Quarter | Amount | Revenue | Cumulative Revenue | % of Total | Orders > $500 | |
| 2 | O-1001 | Europe | 2026-01-08 | Q1 | 720 | 14400 | 5 | |||
| 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
Passed30s · N/A
J2=COUNTIF(E2:E8,">500")
| 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 | 5 | |||
| 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
Passed13s · 0.1¢
J2=COUNTIF(E2:E1000,">500")
| 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 | 5 | |||
| 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
Passed2m 15s · 38¢
J2=COUNTIF(E2:E9,">500")
| 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 | 5 | |||
| 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
Passed5s · 0.3¢
J2=COUNTIF(E2:E8,">500")
| 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 | 5 | |||
| 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
Passed22s · 0.2¢
J2=COUNTIF(E2:E1000,">500")
| 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 | 5 | |||
| 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
Passed5s · 0.1¢
J2=COUNTIF(Orders!E2:E9,">500")
| 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 | 5 | |||
| 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
Passed15s · N/A
J2=COUNTIF(E2:E9,">500")
| 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 | 5 | |||
| 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
Passed24s · N/A
J2=COUNTIF(E2:E1000,">500")
| 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 | 5 | |||
| 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
Passed15s · 0.4¢
J2=COUNTIF(E:E,">500")
| 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 | 5 | |||
| 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
Passed33s · N/A
J2=COUNTIF(E2:E8, ">500")
| 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 | 5 | |||
| 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
Passed19s · 30¢
J2=COUNTIF(E2:E8,">500")
| 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 | 5 | |||
| 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
Passed17s · 0.3¢
J2=COUNTIF(E2:E8,">500")
| 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 | 5 | |||
| 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 |