Your formulas.
Written by machines.

=SUMIFS(D:D, A:A, ">="&DATE(2024,1,1), A:A, "<"&DATE(2024,2,1), C:C, "LATAM")

{
  "chart": "grouped_bar",
  "x": "month",
  "y": "revenue",
  "group": "category",
  "insights": [
    "Q4 shows 34% growth",
    "Electronics leads at $2.1M"
  ]
}

SELECT c.name, COUNT(o.id) AS purchases
FROM customers c
JOIN orders o ON c.id = o.customer_id
WHERE o.created_at >= DATE_TRUNC('month', NOW())
GROUP BY c.name
HAVING COUNT(o.id) > 3
ORDER BY purchases DESC;

| Item          | Qty | Unit Price | Total    |
|---------------|-----|------------|----------|
| Widget A      |  50 |     $12.99 |   $649.50|
| Widget B      | 120 |      $8.50 | $1,020.00|
| Service Fee   |   1 |    $150.00 |   $150.00|
|               |     |  Subtotal: | $1,819.50|

This formula does a two-criteria lookup:

1. INDEX(...) — Returns a value from a range
2. MATCH(1, (A2:A100=F2)*(B2:B100=G2), 0)
   → Finds the row where BOTH conditions are true:
   • Column A matches the value in F2
   • Column B matches the value in G2
3. MATCH("Revenue", A1:Z1, 0)
   → Finds the column labeled "Revenue"

⚡ This is an array formula — press Ctrl+Shift+Enter