tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 874204d1720768823-sum-calculation-kaffleck-sumproduct-aligw
Sheet: Sheet1

Ordered by | Lead time Days | Course | Category | Delivered | Received by | Date Ordered | Item | Quantity | supplier | Code | Unit cost £ | Total cost £ | REQ | UOE | COMMENTS
JH | 3 | company 1 | Chemical | 2024-01-05 00:00:00 |  | 2024-01-04 00:00:00 | Chem 1 | 1 | x | x | 26.4 |  | REQ1 | UOE1
KA | None given | company 1 | S | 2024-01-24 00:00:00 |  | 2024-01-08 00:00:00 | s | 1 | x | x | 15.8 |  | REQ2 | UOE2
KA | None given | company 2 | Chemical | 2023-01-10 00:00:00 |  | 2024-01-08 00:00:00 | Chem 2 | 1 | x | x | 66.43 |  | REQ3 | UOE3
KA | None given | company 2 | Chemical | 2024-01-08 00:00:00 |  | 2024-01-08 00:00:00 | chem 3 | 1 | x | x | 51.36 |  | REQ4 | 4
KA | None given | company 3 | Equipment | 2024-01-15 00:00:00 |  | 2024-01-09 00:00:00 | Equipment 1 | 1 | x | x | 212.99 |  | REQ5 | UOE5
KA | None given | company 4 | Chemical | 2024-01-15 00:00:00 |  | 2024-01-09 00:00:00 | chem 4 | 2 | x | x | 59 |  | [NAME] | UOE6
KA | None given | company 5 | Chemical | 2024-01-15 00:00:00 |  | 2024-01-09 00:00:00 | chem 5 | 1 | x | x | 71 |  | REQ7 | UOE7
KA | None given | company 6 | Chemical | 2024-01-15 00:00:00 |  | 2024-01-09 00:00:00 | chem 6 | 3 | x | x | 63 |  | REQ8 | UOE8
KA | None given | company 7 | Chemical | 2024-01-15 00:00:00 |  | 2024-01-09 00:00:00 | chem 7 | 1 | x | x | 25 |  | [NAME] | UOE9
Spreadsheet: louise_kitchen__24241__July Orig w notes
Sheet: Derivatives

Derivatives
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Derivatives |  | 958135
Smith, [NAME] |  | Gas |  | Derivatives |  | 482838
Abramo |  | Gas |  | Derivatives |  | 312911
Black |  | Gas |  | Derivatives |  | 259026
[NAME] |  | Gas |  | Derivatives |  | 214634
Otto |  | Gas |  | Derivatives |  | 200816
Lagrasta |  | Gas |  | Derivatives |  | 105950
Breslau |  | Gas |  | Derivatives |  | 38668
Titus |  | Gas |  | Derivatives |  | 36430
Shipos |  | Gas |  | Derivatives |  | 30332
Figueroa |  | Gas |  | Derivatives |  | 29726
[NAME] |  | Gas |  | Derivatives |  | 29707
Ortiz |  | Gas |  | Derivatives |  | 11505
Barbe |  | Gas |  | Derivatives |  | 7600
Singer |  | Gas |  | Derivatives |  | 1812
Breglam |  | Gas |  | Derivatives |  | 273
Total
Spreadsheet: 489468d1479277266-database-help-from-database-list-to-nice-looking-list-example-file
Sheet: Example

 |  |  |  |  |  |  | Helper Column
non array formula |  | [NAME]
Spreadsheet: 470928d1468778346-distributing-data-evenly-between-work-colleagues-group15
Sheet: Data How I need it to end up

Work List 1 |  | Work List 2 |  | Work List 3 |  | Work List 4 |  | Work List 5 |  | Work List 6 |  | Work List 7 |  | Work List 8 |  | Work List 9 |  | Work List 10
Spreadsheet: richard_sanders__31728__Outgoing Collateral Status to PX and ISO as of 070901
Sheet: Outstanding Collateral to PX

Outstanding Cash and Letters of Credit Currently Issued by EPMI in favor of CA Power Exchange Corp. / CalPX Trading Services, a div. Of CAPX
CORE MARKET (DAY OF/DAY AHEAD)
Collateral Form (Cash or L/C No.) | Beneficiary | Issuing/Receiving Bank |  | L/C Amount | L/C Expiry
CASH (request on 1/16/01 in by 6:30am 1/17/01) | The California Power Exchange Corp. | Bank of America |  | 3570788
 |  | (aba121000358)
 |  | (acct no1233427058)
 |  | Total in Cash
(1) LETTER OF CREDIT:
G390148 | The California Power Exchange Corp. | Toronto-Dominion |  | 15000000 | 2001-07-31 00:00:00
 |  | Total in Letter of Credit
 |  | Letter Agreement
 |  | TOTAL FOR CORE MARKET | =====>
CTS MARKET (BLOCK FORWARD)
Collateral Form (Cash or L/C No.) | Beneficiary | Issuing Bank |  | L/C Amount | L/C Expiry
Cash (drawn off of Letters of Credit as of 2/1/01)
Previous L/C No. 3016973 | CalPX Trading Services | drawn from Bank of America |  | 15000000 | CASH
Previous L/C No. 870-123057 | CalPX Trading Services | drawn from Wachovia |  | 14500000 | CASH
Previous L/C No. S9702574 | CalPX Trading Services | drawn from Standard Charter |  | 7000000 | CASH
 |  | Total in Cash
(3) LETTERS OF CREDIT:
3016972 | CalPX Trading Services | Bank of America |  | 40290000 | 2001-07-31 00:00:00
5060/820 | CalPX Trading Services | ANZ Investment |  | 27000000 | 2001-07-31 00:00:00
SLC0000126 | CalPX Trading Services | [NAME] |  | 25000000 | 2001-09-28 00:00:00
 |  | Total in Letters of Credit
 |  | Total for Block FW | =====>
 |  | TOTAL POSTED COLLATERAL
Spreadsheet: 264291d1378836444-how-to-find-the-variation-between-two-sheets-sample
Sheet: Product Level

Invoice# | Product Name | Billed Amt | Discout Amt | After reprice amt
D123 | Pen | 66.66666666666667 | 10
D123 | Pencil | 66.66666666666667 | 5
D123 | Box | 66.66666666666667 | 5
D124 | Note Book | 59 | 5
D124 | pen | 50 | 2
D124 | Pencil | 50 | 2
D125 | Globe | 1234 | 111
D126 | colour Pencils | 1500 | 10
D126 | Colouring book | 842 | 6
D126 | Sketch Board | 1500 | 6
D127 | Boarding Bed | 23232 | 222
D128 | Study Chair | 1342 | 10
D129 | Bed | 5615 | 32.75
D129 | Bed | 5611.5 | 32.75
D130 | Laptop | 9972.99999999999 | 22
D131 | Laptop | 9998.29999999999 | 222
D132 | PC | 10023.6 | 10
D133 | PC | 10048.9 | 65.5
D134 | DEL PC | 10074.2 | 55.2
D135 | PC table | 10099.5 | 44.9
D136 | Laptop covers | 3842 | 22
D137 | Matrix | 23232 | 222
D138 | Bag | 1342 | 10
D139 | AMD PC | 11223 | 65.5
D140 | Game on | 9000 | 55.2
D140 | remotes | 974 | 0
D141 | chair | 1416.280952380951 | 6.414285714285714
D141 | chair | 1416.280952380951 | 6.414285714285714
D141 | chair | 1416.280952380951 | 6.414285714285714
D141 | chair | 1416.280952380951 | 6.414285714285714
D141 | chair | 1419 | 8
D141 | chair | 1416.280952380951 | 6.414285714285714
D141 | chair | 1416.280952380951 | 6.414285714285714
D142 | Table | 2475.78095238095 | 55.5
D142 | Table | 2475.78095238095 | 55.5
D142 | Table | 2475.78095238095 | 55.5
D142 | Table | 2475.78095238095 | 55.5
D143 | Boarding Bed | 9892.28095238094 | 222
D144 | Study Chair | 9857.34285714284 | 265.86
D145 | Bed | 9832.04285714284 | 313.84
D146 | Bed | 9806.74285714284 | 380
D147 | Laptop | 9781.44285714284 | 409.8
D148 | Study Chair | 9756.14285714284 | 456.132
D149 | Bed | 9730.84285714284 | 503.288
D150 | Table | 9705.54285714284 | 550.444
Spreadsheet: 285922d1387923332-how-to-link-2-work-sheet-workinghourslist
Sheet: DATA

NAME | MONTH | TOTAL WORKING HRS | REGULAR WORKING HRS | OVERTIME WORKING HRS
EMPLOYEE_01 | JANUARY | 200 | 200
 | FEBRUARY | 221 | 200
 | [NAME] | 201 | 200
 | APRIL | 203 | 200
 | MAY | 202 | 200
 | [NAME] | 230 | 200
 | JULY | 215 | 200
 | AUGUST | 205 | 200
 | SEPTEMBER | 215 | 200
 | OCTOBER | 210 | 200
 | NOVEMBER | 221 | 200
 | DECEMBER | 218 | 200
 | TOTAL
EMPLOYEE_02 | JANUARY | 201 | 200
 | FEBRUARY | 202 | 200
 | [NAME] | 204 | 200
 | APRIL | 203 | 200
 | MAY | 222 | 200
 | [NAME] | 206 | 200
 | JULY | 208 | 200
 | AUGUST | 209 | 200
 | SEPTEMBER | 215 | 200
 | OCTOBER | 211 | 200
 | NOVEMBER | 221 | 200
 | DECEMBER | 218 | 200
 | TOTAL
EMPLOYEE_03 | JANUARY | 210 | 200
 | FEBRUARY | 220 | 200
 | [NAME] | 219 | 200
 | APRIL | 218 | 200
 | MAY | 215 | 200
 | [NAME] | 214 | 200
 | JULY | 216 | 200
 | AUGUST | 200 | 200
 | SEPTEMBER | 219 | 200
 | OCTOBER | 203 | 200
 | NOVEMBER | 202 | 200
 | DECEMBER | 218 | 200
 | TOTAL
EMPLOYEE_04 | JANUARY | 211 | 200
 | FEBRUARY | 207 | 200
 | [NAME] | 209 | 200
 | APRIL | 203 | 200
 | MAY | 210 | 200
 | [NAME] | 222 | 200
 | JULY | 212 | 200
 | AUGUST | 207 | 200
 | SEPTEMBER | 214 | 200
 | OCTOBER | 200 | 200
 | NOVEMBER | 213 | 200
 | DECEMBER | 224 | 200
 | TOTAL
Spreadsheet: 668684d1584978270-for-bachelors-thesis-a-way-to-look-up-how-many-times-two-or-more-numbers-go-into-one-book1-staleskullerud-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Full 2870 products | Full 1670 products | Three quarter 2870 products | Discounted 1670 products | Discounted Three quarter 2870 products
 |  |  |  |  |  |  |  |  |  |  |  | Invoice | 2870 | 1670 |  | 179
Example1: An invoice has a total amount of 4540. this is the sum of 2870 and 1670, one of each product. |  |  |  |  |  |  |  |  |  |  |  | 4540
Example2: An invoice has a total amount of 5740. 2*2870, two times one product. |  |  |  |  |  |  |  |  |  |  |  | 5740
Example3: An invoice has a total amount of 2152.5. (3/4)*2870. Due to only 3/4 of the product delivered. |  |  |  |  |  |  |  |  |  |  |  | 2152.5
Example4: An invoice has a total amount of 7231. 2*2870 + 1*1670 - 179(discount) |  |  |  |  |  |  |  |  |  |  |  | 7231
1973.5, (3/4)*2870 minus a discount of 179. |  |  |  |  |  |  |  |  |  |  |  | 1973.5
Spreadsheet: 817955d1676526704-find-and-match-in-excel-using-two-data-tables-book1-movie-titles
Sheet: Sheet1

Employee Name | Movie 1 | Movie 2 | Movie 3 |  | Employee Name | Movie 1 | Movie 2 | Movie 3 |  | Movie Codes | Movie |  | Employee Name | Movie 1 | Movie 2 | Movie 3
[NAME], [NAME] |  |  |  |  | [NAME], [NAME] | Dance 1 | Up n Go | Drive |  | 1 | Dance 1, Dance |  | [NAME], [NAME] | 1 | 2 | 3
[NAME], [NAME] |  |  |  |  | [NAME], [NAME] | ET | Banjo |  |  | 2 | Up n Go |  | [NAME], [NAME] | 4 | 5
[NAME], An |  |  |  |  | [NAME], An | [NAME] |  |  |  | 3 | Drive |  | [NAME], An | 6
[NAME], [NAME] |  |  |  |  | [NAME], [NAME] | 1st n Last | Dance 1 | Banjo |  | 4 | ET |  | [NAME], [NAME] | 7 | 1 | 5
Bruce, Le |  |  |  |  | Bruce, Le | Up n Go | Drive |  |  | 5 | Banjo |  | Bruce, Le | 2 | 3
 |  |  |  |  |  |  |  |  |  | 6 | [NAME]
Fill above data using Reference Data 1 and 2 but in Movie Codes |  |  |  |  | Reference Data |  |  |  |  | 7 | 1st n Last |  | Desired results above
 |  |  |  |  |  |  |  |  |  | Reference Data
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Grout

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 842386d1694482657-conditional-formatting-based-upon-dates-quibilty-dates-reocurring2
Sheet: Solution

2024-01-19 00:00:00
2024-02-02 00:00:00
2024-02-16 00:00:00
2024-03-01 00:00:00
2024-03-15 00:00:00
2024-03-29 00:00:00
2024-04-12 00:00:00
2024-04-26 00:00:00
2024-05-10 00:00:00
2024-05-24 00:00:00
2024-06-07 00:00:00
2024-06-21 00:00:00
2024-07-05 00:00:00
2024-07-19 00:00:00
2024-08-02 00:00:00
2024-08-16 00:00:00
2024-08-30 00:00:00
2024-09-13 00:00:00
2024-09-27 00:00:00
2024-10-11 00:00:00
2024-10-25 00:00:00
2024-11-08 00:00:00
2024-11-22 00:00:00
2024-12-06 00:00:00
2024-12-20 00:00:00
2025-01-03 00:00:00
2025-01-17 00:00:00
2025-01-31 00:00:00
2025-02-14 00:00:00
2025-02-28 00:00:00
2025-03-14 00:00:00
2025-03-28 00:00:00
2025-04-11 00:00:00
2025-04-25 00:00:00
2025-05-09 00:00:00
2025-05-23 00:00:00
2025-06-06 00:00:00
2025-06-20 00:00:00
2025-07-04 00:00:00
2025-07-18 00:00:00
2025-08-01 00:00:00
2025-08-15 00:00:00
2025-08-29 00:00:00
2025-09-12 00:00:00
2025-09-26 00:00:00
2025-10-10 00:00:00
2025-10-24 00:00:00
2025-11-07 00:00:00
2025-11-21 00:00:00
2025-12-05 00:00:00
2025-12-19 00:00:00
2026-01-02 00:00:00
Spreadsheet: 92829d1292361808-if-formula-problem-checking-each-cell-for-an-answer-book1-2
Sheet: Sheet1

1 | xxxxxxx | xxxxxxx | 9 | 6 | 9 | 10 | 10 | 7 | 9 | 7 | 10 | 8 | 10 | 8 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 9.055555555555555 | ADMIS
2 | yyyyyyy | yyyyyyyy | 9 | 6 | 10 | 7 | 9 | 9 | 9 | 6 | 10 | 8 | 10 | 8 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 8.88888888888889 | ADMIS
3 | aaaaaaaaa | aaaaaaaaaaa | 10 | 10 | 9 | 7 | 9 | 8 | 9 | 8 | 10 | 10 | 10 | 9 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 9.38888888888889 | ADMIS
4 | bbbbbbb | bbbbbbb | 7 | 8 | 9 | 4 | 9 | 9 | 9 | 6 | 10 | 9 | 10 | 8 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 8.722222222222221 | RESPINS
5 | cccccccccc | ccccccccccc | 7 | 8 | 8 | 7 | 9 | 8 | 8 | 6 | 10 | 8 | 10 | 7 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 8.666666666666666 | ADMIS
6 | ddddddddd | ddddddd | 8 | 9 | 9 | 7 | 9 | 7 | 7 | 7 | 9 | 9 | 10 | 7 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 8.722222222222221 | ADMIS
7 | eeeeeeee | eeeeeee | 9 | 9 | 9 | 7 | 9 | 9 | 8 | 7 | 10 | 9 | 10 | 8 | 10 | 10 | 10 | 10 | 10 | 10 |  | 18 | 9.11111111111111 | ADMIS
8 | [NAME] | ffffffff | 10 | 10 | 10 | 8 | 10 | 8 | 8 | 8 | 10 | 9 | 10 | 8 | 10 | 10 | 10 | 9 | 10 | 10 |  | 18 | 9.333333333333334 | ADMIS
Spreadsheet: 818689d1677000558-formula-for-only-adding-cells-when-both-cells-contain-data-lots-excel-example-tms
Sheet: Lots Tab

 |  | Site A |  | Site B
 |  | Lot 1 |  | Lot 2
 | Product 1 | 4.99
 | product 2 | 3.99 |  | 1.5
 | Product 3 | 2.99 |  |  |  | If a client only wants Site A (Lot 1 ) then they will enter their pricing for all the cells in colum C Only. the Total of this (C9) is linked to the Summary Tab If the Client only requires Site B (Lot 2) then they will enter pricing into all the cells in column D Only The Total of this is linked to the [NAME]  If the client wished to have both Sites (Lots 1 &2) then the client enters pricing in both column C & D, again this is linked to the summary [NAME]  On the Summary Tab if both [NAME] are linked and if both  are selected i need to shown this as Lot 3 on the Summary Tab Only  Feel free to enter prices in either colum C&D.
 | Product 4 | 10.99
 | Product 5 | 11.75
 | Product 6 | 18.62
 | Totals
Spreadsheet: 166141d1341485869-excel-2007-sumifs-with-multiple-criteria-sum-ifs-with-multiple-criteria
Sheet: Sheet1

Customer | Paid/Unpaid | Amount |  | Total paid by [NAME] and [NAME] |  |  |  | [NAME]
[NAME] | Paid | 10 |  |  |  |  |  | [NAME]
[NAME] | Paid | 20
[NAME] | Unpaid | 30
[NAME] | Paid | 40
[NAME] | Unpaid | 50
[NAME] | Paid | 60
[NAME] | Unpaid | 70
Spreadsheet: 689303d1596276831-need-formula-to-count-by-two-way-lookup-book3
Sheet: Sheet1

Criteria 1 | Criteria2 | Req.Result |  | For Criteria 1 | For [NAME]
03.ABC | [NAME] | 2
03.ABC | WXYZ1490 | 2
03.ABC | WXYZ1510 | 2
03.ABC | [NAME] | 1
03.ABC | [NAME] | 1
03.ABC | WXYZ1510 | 2
04.XYZ | WXYZ1490 | 2
03.ABC | [NAME] | 2 |  |  |  |  |  |  |  |  | Need to Count Criteria 1 based on criteria 2
03.ABC | WXYZ1490 | 2
04.XYZ | [NAME] | 2
16.PQR | WXYZ1330 | 1
16.PQR | WXYZ1330 | 1
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 1
03.ABC | [NAME] | 1
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 1
03.ABC | [NAME] | 1
03.ABC | [NAME] | 1
03.ABC | [NAME] | 1
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | [NAME] | 2
03.ABC | WXYZ1510 | 2
03.ABC | WXYZ1510 | 2
05.EFG | WXYZ1510 | 2
03.ABC | WXYZ1510 | 2
Spreadsheet: 680334d1590950307-update-array-formulas-automatically-array-formula-copy
Sheet: Sheet1

 | Price | M/M % | Trend
2019-01-01 00:00:00 | 30
2019-02-01 00:00:00 | 31
2019-03-01 00:00:00 | 34 |  | 0.04301120537286247
2019-04-01 00:00:00 | 34 |  | 0.0371438363889087
2019-05-01 00:00:00 | 33 |  | 0.03127646740495491
2019-06-01 00:00:00 | 35 |  | 0.02540909842100113
2019-07-01 00:00:00 | 38 |  | 0.01954172943704735
2019-08-01 00:00:00 | 33 |  | 0.01367436045309357
2019-09-01 00:00:00 | 38 |  | 0.007806991469139782
2019-10-01 00:00:00 | 39 |  | 0.001939622485185998
2019-11-01 00:00:00 | 37 |  | -0.003927746498767787
2019-12-01 00:00:00 | 36 |  | -0.009795115482721564
Spreadsheet: 480617d1473996006-how-to-sum-group-of-duplicates-with-several-other-criteria-using-a-formula-duplicate-summation
Sheet: Sheet1

Control Number | R Code | RR Code | Hours | Total Hours
4032368 | 5 | PM | 0 |  |  | The summation should be in the bottom of the
5070380 | 9 | TF | 1.08 |  |  | duplicate row
5070380 | 9 | TF | 0.495 |  |  |  |  |  |  | The criteria should be
5070380 | 9 | TF | 0.405 |  |  |  |  |  | a | Sum D values with duplicates in A (yellow)
5070380 | 9 | TF | 1.0575 |  |  |  |  |  | b | Sum only if R Code is 9
5070380 | 10 | DA | 0 | 0 | 0 since criteri c is false |  |  |  | c | Sum only if R Code is 9 WITH R Code of 5 in the same group
5130778 | 1 | EP | 0.4500000000000001 |  |  |  |  |  | * | Sum only those with R Code 9
5409856 | 1 | EP | 0
5415322 | 4 | DR | 0.6300000000000001
5415322 | 4 | DR | 2.52
5415322 | 9 | TF | 0 | 0 | 0 since criteri c is false
5416878 | 1 | EP | 0
5449540 | 5 | PM | 11.835
5449540 | 5 | PM | 3.375
5449540 | 5 | PM | 0
5449540 | 9 | TF | 8.662500000000001
5449540 | 9 | TF | 2.43
5449540 | 9 | TF | 3.51 | 14.6025 | Meets the criteria, should SUM only those with R Code 9
Code
5 | PM
9 | TF
1 | EP
10 | DA
4 | DR
Spreadsheet: 836658d1689569496-sum-formula-error-fornightly-pay-calculation-copy
Sheet: FYR Summary

CDU Casual Remediation - Financial Year Summary
20XX/XX
Surname: | ABC
First Name: | Xyz
Employee ID: | 123
Financial Year | Pay Number | Amount Underpaid (Gross) | Interest | Fortnightly Total Owed | FYR Total | Super (On Ordinary Time Earnings (OTE) only) |  | Superannuation OTE
 |  |  |  |  |  | 0.105 |  | [NAME] | Super Adjustment
 | Pay 01
 | Pay 02
 | Pay 03
 | Pay 04
 | Pay 05
 | Pay 06
 | Pay 07
 | Pay 08
 | Pay 09
 | Pay 10
 | Pay 11
 | Pay 12
 | Pay 13
 | Pay 14
 | Pay 15
 | Pay 16
 | Pay 17
 | Pay 18
 | Pay 19
 | Pay 20
 | Pay 21
 | Pay 22
 | Pay 23
 | Pay 24
 | Pay 25
 | Pay 26
Spreadsheet: 770763d1646243505-unique-and-filter-inside-countif-s-function-unique-filter-inside-countifs-function
Sheet: Sheet1

Subject | Student | Score |  |  | Subject | Score
ENGLISH | [NAME] | D |  |  | BIOLOGY | A |  |  |  |  |  | A
PHYSICS | [NAME] | B |  |  |  | C |  |  | #[NAME]! |  | BIOLOGY | C
ENGLISH | Doe | E |  |  |  | D |  |  | #[NAME]! |  | BIOLOGY | D
HISTORY | [NAME] | E |  |  | CHEMISTRY | A |  |  | #[NAME]! |  | CHEMISTRY | A
GEOGRAPHY | [NAME] | B |  |  | ENGLISH | A |  |  | #[NAME]! |  | ENGLISH | A
ENGLISH | [NAME] | A |  |  |  | D |  |  | #[NAME]! |  | ENGLISH | D
GEOGRAPHY | [NAME] | A |  |  |  | E |  |  | #[NAME]! |  | ENGLISH | E
ENGLISH | Doe | D |  |  | GEOGRAPHY | A |  |  | #[NAME]! |  | GEOGRAPHY | A
PHYSICS | [NAME] | A |  |  |  | B |  |  | #[NAME]! |  | GEOGRAPHY | B
HISTORY | [NAME] | A |  |  | HISTORY | A |  |  | #[NAME]! |  | HISTORY | A
GEOGRAPHY | [NAME] | A |  |  |  | C |  |  | #[NAME]! |  | HISTORY | C
PHYSICS | [NAME] | D |  |  |  | E |  |  | #[NAME]! |  | HISTORY | E
MATHEMATICS | Doe | B |  |  | MATHEMATICS | B |  |  | #[NAME]! |  | MATHEMATICS | B
HISTORY | [NAME] | C |  |  | PHYSICS | A |  |  | #[NAME]! |  | PHYSICS | A
PHYSICS | [NAME] | B |  |  |  | B |  |  | #[NAME]! |  | PHYSICS | B
BIOLOGY | [NAME] | A |  |  |  | D |  |  | #[NAME]! |  | PHYSICS | D
PHYSICS | [NAME] | A
BIOLOGY | [NAME] | D
CHEMISTRY | Doe | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | C
Spreadsheet: 710275d1608816928-column-counting-for-drop-down-box-vs-quantity-alex
Sheet: Numbers

Numbers | Cost |  | Numbers
1 | 3 |  | 1
2 | 6 |  | 2
3 | 9 |  | 3
4 | 12 |  | 4
5 | 15 |  | 5
6 | 18 |  | 6
7 | 21 |  | 7
8 | 24 |  | 8
9 | 27 |  | 9
10 | 30 |  | 10
11 | 33 |  | 11
12 | 36 |  | 12
13 | 39 |  | 13
14 | 42 |  | 14
15 | 45 |  | 15
16 | 48 |  | 16
17 | 51 |  | 17
18 | 54 |  | 18
19 | 57 |  | 19
20 | 60 |  | 20
Spreadsheet: 675782d1588492238-single-answer-from-variable-drop-down-menus-colours
Sheet: Sheet1

 | a | b | c | d
RED - 1 | 10 | 20 | 30 | 40
RED - 2 | 15 | 30 | 45 | 60
RED - 3 | 12 | 24 | 36 | 54
RED - 1 | b |  |  |  | 20
Spreadsheet: 80627d1280849676-excel-hide-unhide-rows-columns-excel-feature
Sheet: CSV-VList (2)

Demo Launch Excel Framework
<NewWorkbook=Yes> |  |  | Optional Keywords in Title section of script
<SaveAs=No>
<ProtectSheets=No>
<Password=>
<DisplayCSV=Yes>
Property=.actprop
Post Month (For IS)=12/2007
Template=T-VList
Report_Name | Template_Name | Range_Name | Page_Number | Columns | Data01 | Data02 | Data03 | [NAME] | Data05 | [NAME] | Data07 | Data08 | iUnderline | bBold | bItalic | sRowType | hDetail | hTotalInto | iFactor
Vertical List | T-VList | v_R03_C00_Property | 1 | 8 | affcombo | HUD 202/Tax Credit Combo Prop | 8823 Free Street | Kansas City|^| MO | 2008-01-15 00:00:00 |  | 40 | #FormulaR1C1#=IF(ISERR(RC[-1]+R[-1]C)|^|RC[-1]|^|RC[-1]+R[-1]C)
Spreadsheet: cdd913b9-c386-49f0-a425-dad59440d943
Sheet: Sheet1

Tabel 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Begeleide [NAME] jaar of ouder naar achtergrondkenmerken, 2010
-
 | Totaal | Zelfstandig reizen | Begeleid reizen
-
 | %
 | ----------------------------------------------------------------------------
Totaal verplaatsingen | 100 | 76 | 24
Geslacht
Man | 100 | 78 | 22
Vrouw | 100 | 74 | 26
Leeftijd
75 tot 80 jaar | 100 | 78 | 22
80 jaar en ouder | 100 | 73 | 27
Reisafstand
0,1 tot 1 km | 100 | 87 | 13
1 tot 5 km | 100 | 78 | 22
5tot 15 km | 100 | 68 | 32
15 tot 30 km | 100 | 62 | 38
30 km of meer | 100 | 59 | 41
[NAME]
7 tot 20 uur | 100 | 76 | 24
Na 20.00 uur | 100 | 66 | 34
Vervoermiddel
Fiets/bromfiets | 100 | 92 | 8
Lopend | 100 | 85 | 15
Openbaar vervoer | 100 | 80 | 20
Auto | 100 | 62 | 38
w.o. als bestuurder | 100 | 78 | 22
w.o. als passagier | 100 | 32 | 68
Anders | 100 | 74 | 26
Motief
Winkelen | 100 | 80 | 20
Recreatief | 100 | 75 | 25
Diensten/ persoonlijke verzorging | 100 | 72 | 28
Visite/ logeren | 100 | 67 | 33
Anders | 100 | 78 | 22
-
Bron: CBS, [NAME] in Nederland.
Spreadsheet: 676203d1588701085-countif-varying-range-data-1-
Sheet: Result

Week |  | Result |  | Result should be
15
16
17 |  |  |  | 1
18 |  |  |  | 1
19
20
21
22
23
24
25
25
27
28
Spreadsheet: 96072d1295535911-formula-to-calculate-money-due-order-book
Sheet: GW Turner

WEEK ENDING | AMOUNT
 | 6000
 | 1000
 | 1000
 | 1000
 | 1000
 | 1000
 | 2000
TOTAL
Spreadsheet: 882377d1730752946-need-help-with-a-sumifs-formula-sample
Sheet: Sample

[NAME] | Test sample | Received Qty x Test Sample | Fiscal Month
48980 | 900 | 44082000 | [NAME]
50720 |  |  | [NAME]
50640 | 99 | 5013360 | [NAME]
51020 |  |  | [NAME]
51180 |  |  | [NAME]
50720 | 99 | 5021280 | [NAME]
50760 | 200 | 10152000 | [NAME]
49600 |  |  | [NAME] |  | NUMERATOR
50540 | 99 | 5003460 | [NAME] |  | DENOMINATOR
Spreadsheet: 79770d1279971155-trouble-aggregating-individual-entries-into-statistics-drink-sheet
Sheet: drinks.

drinking. | 2010-07-24 00:00:00 |  |  |  | drink statistics (by day). |  |  |  | drink statistics (total).
Date | Time | Drink | Vol |  | date | statistic | #
2010-07-24 00:00:00 | 00:00:00 | Saleen |  |  | 2010-07-24 00:00:00 | total drink |  |  | total drink
2010-07-24 00:00:00 | 00:05:00 | Water | 240 |  |  | avg drink |  |  | avg drink per drink
2010-07-24 00:00:00 | 00:40:00 | Water | 240 |  |  | # drink |  |  | SD drink per drink
 |  |  |  |  | 2010-07-25 00:00:00 | total drink |  |  | [NAME] drink
 |  |  |  |  |  | avg drink |  |  | min drink
 |  |  |  |  |  | # drink |  |  | avg drink vol / day
 |  |  |  |  | 2010-07-26 00:00:00 | total drink |  |  | SD drink vol / day
 |  |  |  |  |  | avg drink |  |  | [NAME] drink vol / day
 |  |  |  |  |  | # drink |  |  | min drink vol / day
 |  |  |  |  | 2010-07-27 00:00:00 | total drink |  |  | avg # drink / day
 |  |  |  |  |  | avg drink |  |  | SD # drink / day
 |  |  |  |  |  | # drink |  |  | [NAME] drink # /day
 |  |  |  |  | 2010-07-28 00:00:00 | total drink |  |  | min drink # / day
 |  |  |  |  |  | avg drink |  |  | avg time btwn drink
 |  |  |  |  |  | # drink |  |  | drink rate (ml/hr)
 |  |  |  |  | 2010-07-29 00:00:00 | total drink
 |  |  |  |  |  | avg drink |  |  | start time
 |  |  |  |  |  | # drink |  |  | current time
 |  |  |  |  | 2010-07-30 00:00:00 | total drink
 |  |  |  |  |  | avg drink
 |  |  |  |  |  | # drink
 |  |  |  |  | 2010-07-31 00:00:00 | total drink
 |  |  |  |  |  | avg drink
 |  |  |  |  |  | # drink