Summarize spend by department
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Add a department spend summary to Sheet1 starting at H1. Use one header row, list the departments alphabetically, and calculate total spend with formulas.
Add average transaction size and transaction count to the same summary, using formulas for both.
Starting spreadsheet
Sheet1 · rows 1–21 of 52| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | |
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 |
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 |
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 |
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 |
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 |
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 |
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 |
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 |
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 |
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 |
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 |
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 |
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 |
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
A passing output
Autosheet in Excel · Opus 5.5I2=SUMIFS($F$2:$F$51,$C$2:$C$51,H2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | €23,370.50 | 11 | €2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | €34,520.00 | 9 | €3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | €14,070.00 | 9 | €1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | €13,619.00 | 11 | €1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | €6,086.80 | 10 | €608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | €91,666.30 | 50 | €1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Pass criteria
All must be met, checked automatically.H2:I6hold the expected valuesI2:K6use formulas- Average transaction size and transaction count columns in either order (2 accepted ways)
Passed 22
Autosheet in Excel Opus 5.5 · Medium
I2=SUMIFS($F$2:$F$51,$C$2:$C$51,H2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | €23,370.50 | 11 | €2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | €34,520.00 | 9 | €3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | €14,070.00 | 9 | €1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | €13,619.00 | 11 | €1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | €6,086.80 | 10 | €608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | €91,666.30 | 50 | €1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Excel GPT-6 Astra · Low
H2=_xlws.SORT(UNIQUE(_xlws.FILTER(C2:C52,C2:C52<>"")))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | $2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | $3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | $1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | $1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | $608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Sheets Opus 5.5 · Medium
I2=SUMIF($C$2:$C$51, H2, $F$2:$F$51)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | 11 | $2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | 9 | $3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | 9 | $1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | 11 | $1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | 10 | $608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Excel Sonnet 5.5 · Medium
I2=SUMIFS($F$2:$F$51,$C$2:$C$51,H2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Average Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | 11 | $2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | 9 | $3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | 9 | $1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | 11 | $1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | 10 | $608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | $91,666.30 | 50 | $1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Claude in Excel Opus 5.5 · High
I2=SUMIFS($F:$F,$C:$C,H2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 11 | 2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 9 | 3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 9 | 1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 11 | 1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 10 | 608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Excel Haiku 5.5 · High
I2=SUMIF($C$2:$C$52,H2,$F$2:$F$52)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Average Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 11 | 2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 9 | 3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 9 | 1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 11 | 1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 10 | 608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | 91,666.30 | 50 | 1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Claude in Sheets Opus 5.5 · Medium
I2=SUMIF($C$2:$C1000,H2,$F$2:$F1000)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | 11 | $2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | 9 | $3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | 9 | $1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | 11 | $1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | 10 | $608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | $91,666.30 | 50 | $1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Claude Code + Sheets MCP Opus 5.5 · Medium
I2=SUMIF($C$2:$C1000,H2,$F$2:$F1000)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Average Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 11 | 2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 9 | 3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 9 | 1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 11 | 1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 10 | 608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Excel GPT-6.1 Sol · Medium
H2=_xlws.SORT(UNIQUE(_xlws.FILTER(C2:C52,C2:C52<>"")))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
I2=SUMIF($C$2:$C$51, H2, $F$2:$F$51)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23370.5 | 11 | 2124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34520 | 9 | 3835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14070 | 9 | 1563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13619 | 11 | 1238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6086.8 | 10 | 608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
ChatGPT + Autosheet MCP GPT-6 · Medium
I2=SUMIF($C$2:$C$51, H2, $F$2:$F$51)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | $2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | $3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | $1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | $1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | $608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Sheets Haiku 5.5 · High
I2=SUMIF($C$2:$C$51,H2,$F$2:$F$51)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Average Transaction | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 11 | 2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 9 | 3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 9 | 1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 11 | 1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 10 | 608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | 91,666.30 | 50 | 1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
ChatGPT in Excel GPT-6 Astra · Medium
I2=SUMIF($C$2:$C$52,H2,$F$2:$F$52)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Claude in Excel Haiku 5.5 · High
I2=SUMIFS(Sheet1!$F:$F,Sheet1!$C:$C,H2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 11 | 2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 9 | 3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 9 | 1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 11 | 1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 10 | 608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | 91,666.30 | 50 | 1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Claude in Sheets Haiku 5.5 · High
I2=SUMIFS($F$2:$F1000,$C$2:$C1000,H2)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Transaction Count | Avg Transaction Size | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | 11 | $2,124.59 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | 9 | $3,835.56 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | 9 | $1,563.33 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | 11 | $1,238.09 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | 10 | $608.68 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | Total | $91,666.30 | 50 | $1,833.33 | |
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Autosheet in Excel GPT-6 Luna · High
I2=SUMIF($C$2:$C$51,H2,$F$2:$F$51)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23370.5 | 2124.590909 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34520 | 3835.555556 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14070 | 1563.333333 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13619 | 1238.090909 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6086.8 | 608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Copilot in Excel Auto
I2=SUMIF($C$2:$C$52,H2,$F$2:$F$52)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | €23,370.50 | €2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | €34,520.00 | €3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | €14,070.00 | €1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | €13,619.00 | €1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | €6,086.80 | €608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
ChatGPT + Drive MCP GPT-6 · Medium
I2=SUMIF($C$2:$C1000,H2,$F$2:$F1000)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
ChatGPT in Excel GPT-6 Luna · High
I2=SUMIF($C:$C,H2,$F:$F)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
Gemini in Sheets Auto
I2=SUMIF($C:$C, H2, $F:$F)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | $2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | $3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | $1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | $1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | $608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
ChatGPT in Sheets GPT-6 Astra · Medium
I2=SUMIF($C$2:$C$51,H2,$F$2:$F$51)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | 23,370.50 | 2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | 34,520.00 | 3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | 14,070.00 | 1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | 13,619.00 | 1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | 6,086.80 | 608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |
ChatGPT in Sheets GPT-6 Luna · High
I2=SUMIF($C:$C,H2,$F:$F)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Transaction ID | Date | Department | Vendor | Category | Amount | Department | Total Spend | Average Transaction Size | Transaction Count | |
| 2 | TXN-001 | 2024-01-03 | Engineering | AWS | Cloud Services | 4820.5 | Engineering | $23,370.50 | $2,124.59 | 11 | |
| 3 | TXN-002 | 2024-01-05 | Marketing | Google Ads | Advertising | 3150 | Finance | $34,520.00 | $3,835.56 | 9 | |
| 4 | TXN-003 | 2024-01-07 | HR | Recruiting | 1200 | HR | $14,070.00 | $1,563.33 | 9 | ||
| 5 | TXN-004 | 2024-01-08 | Finance | QuickBooks | Software | 450 | Marketing | $13,619.00 | $1,238.09 | 11 | |
| 6 | TXN-005 | 2024-01-10 | Operations | FedEx | Shipping | 380 | Operations | $6,086.80 | $608.68 | 10 | |
| 7 | TXN-006 | 2024-01-11 | Engineering | GitHub | Software | 840 | |||||
| 8 | TXN-007 | 2024-01-12 | Marketing | HubSpot | Software | 2100 | |||||
| 9 | TXN-008 | 2024-01-14 | HR | Indeed | Recruiting | 950 | |||||
| 10 | TXN-009 | 2024-01-15 | Operations | Staples | Office Supplies | 215.4 | |||||
| 11 | TXN-010 | 2024-01-17 | Finance | Deloitte | Consulting | 8500 | |||||
| 12 | TXN-011 | 2024-01-18 | Engineering | Datadog | Cloud Services | 1760 | |||||
| 13 | TXN-012 | 2024-01-19 | Marketing | Canva | Software | 180 | |||||
| 14 | TXN-013 | 2024-01-21 | Operations | UPS | Shipping | 490 | |||||
| 15 | TXN-014 | 2024-01-22 | HR | BambooHR | Software | 620 | |||||
| 16 | TXN-015 | 2024-01-23 | Finance | PwC | Consulting | 6200 | |||||
| 17 | TXN-016 | 2024-01-24 | Engineering | Slack | Software | 1320 | |||||
| 18 | TXN-017 | 2024-01-25 | Marketing | Facebook Ads | Advertising | 2800 | |||||
| 19 | TXN-018 | 2024-01-28 | Operations | Amazon Business | Office Supplies | 875.3 | |||||
| 20 | TXN-019 | 2024-01-29 | HR | Workday | Software | 3400 | |||||
| 21 | TXN-020 | 2024-01-30 | Engineering | Snowflake | Cloud Services | 5600 |