tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116199d1311673486-summarizing-or-indexing-book1-1-1-1-1-1-
Sheet: b

Airline Name | Sector Traveled | NettPay |  |  |  |  |  |  |  |  | Hide column L & M |  |  | Data sorted from column L&M |  |  | Highest
[NAME] | Delhi-Bhubaneswar | 5633 |  |  |  |  |  |  |  |  | [NAME] | 59354 |  | [NAME] | 59354 |  | 2
[NAME] | Delhi-Bhubaneswar | 5633 |  |  |  |  |  |  |  |  | Indigo Airlines | 51667 |  | Indigo Airlines | 51667
[NAME] | Delhi-Bhubaneswar | 5633 |  |  |  |  |  |  |  |  | Jet Airways | 22475
[NAME] | Bhubaneswar-Delhi | 5383 |  |  |  |  |  |  |  |  | Spice Jet | 4809
[NAME] | Bhubaneswar-Delhi | 5383 |  |  |  |  |  |  |  |  | Air India | 19248
[NAME] | Bhubaneswar-Delhi | 5383 |  |  |  |  |  |  |  |  |  | 0
Indigo Airlines | Bhubaneswar-Delhi | 5057 |  |  |  |  |  |  |  |  |  | 0
Indigo Airlines | Bhubaneswar-Delhi | 5057 |  |  |  |  |  |  |  |  |  | 0
Indigo Airlines | Delhi-Bhubaneswar | 6073 |  |  |  |  |  |  |  |  |  | 0
Indigo Airlines | Delhi-Bhubaneswar | 9534 |  |  |  |  |  |  |  |  |  | 0
[NAME] | Kolkata-Raipur | 5198 |  |  |  |  |  |  |  |  |  | 0
Jet Airways | [NAME] | 4068 |  |  |  |  |  |  |  |  | Note arrary formula is used in column L and should be confirmed through Shift+Ctrl+Enter |  |  | Note arrary formula is used in column O and should be confirmed through Shift+Ctrl+Enter
Indigo Airlines | Delhi-Bhubaneswar | 6373
[NAME] | Bhubaneswar-Delhi | 5383
Spice Jet | Delhi-Gauhati | 795
[NAME] | Delhi-Bhubaneswar | 5633
[NAME] | Bhubaneswar-Delhi | 5383
Jet Airways | Delhi-Nagpur | 840
Air India | Delhi-Hyderabad | 8745
Indigo Airlines | Vadodara-Delhi | 3413
Jet Airways | [NAME] | 7149
Air India | [NAME] | 4281
Spice Jet | Delhi-Nagpur | 4014
Jet Airways | Delhi-Jodhpur | 7059
[NAME] | Mumbai-Bangalore | 4709
Jet Airways | Bangalore-Mumbai | 3359
Indigo Airlines | Delhi-Ahmedabad | 8775
Air India | Delhi-Raipur | 6222
Indigo Airlines | Delhi-Lucknow-Delhi | 1680
Indigo Airlines | Delhi-Bangalore | 5705
Spreadsheet: 42702d1241257628-updating-a-formula-based-on-multiple-sheets-demo1
Sheet: Summary

No of Items Sold
 | 1 | 2 | 3 | 4
Apple | 24 | 24 | 24 | 24
Mango | 30
[NAME] | 19
Pine Apple | 20
Kiwi | 17
Free
 | 1 | 2 | 3 | 4
Apple | 0
Mango | 30
[NAME] | 0
Pine Apple | 0
Kiwi | 0
Spreadsheet: 825833d1681566420-excell-icon-sets-based-on-date-in-other-cells-budget-transfer-worksheet-test-pthops-
Sheet: Sheet1

STATUS | BT | VERIFIED BY SECTION HEAD | COMPLETION DATE |  | STATUS | BT | VERIFIED BY SECTION HEAD | COMPLETION DATE
● | 1 | 2023-04-11 00:00:00 |  |  |  | 1 | 2023-04-11 00:00:00
 | 2a | 2023-04-11 00:00:00 | 2023-04-11 00:00:00 |  |  | 2a | 2023-04-11 00:00:00 | 2023-04-11 00:00:00
 | 2b |  |  |  |  | 2b
Spreadsheet: 877437d1724263984-drop-drown-calculating-totals-egoche-
Sheet: Sheet3

Lvl | Val 1 | Val 2
2 | 9 | 168 |  | [NAME] | End Lvl | V1 | V2
3 | 10 | 174 |  | 2 | 4
4 | 10 | 183
5 | 11 | 190
6 | 11 | 199
7 | 12 | 205
Spreadsheet: 115486d1311088375-truly-absolute-references-to-cells-using-x-y-coordinates-truly-absolute-references
Sheet: v2

file | artist | album | title
D:\temp\music\01 - pour me a glass (H-Blockx).mp3 | H-Blockx | Time to Move | Pour Me a [NAME]
D:\temp\music\02 - revolution (H-Blockx).mp3 | H-Blockx | Time to Move | Revolution
D:\temp\music\03 - say baby (H-Blockx).mp3 | H-Blockx | Time to Move
D:\temp\music\04 - move (H-Blockx).mp3 | H-Blockx | Time to Move | Move
D:\temp\music\05 - fight the force (H-Blockx).mp3 | H-Blockx | Time to Move | Fight the Force
D:\temp\music\06 - little girl (H-Blockx).mp3 | H-Blockx | Time to Move | Little Girl
D:\temp\music\07 - risin' high (H-Blockx).mp3 | H-Blockx | Time to Move | Risin' High
D:\temp\music\08 - H-Blockx (H-Blockx).mp3
D:\temp\music\09 - real love (H-Blockx).mp3
D:\temp\music\10 - do what you wanna do -- [NAME] don't like it (H-Blockx).mp3 | H-Blockx | Time to Move | Do What You Wanna Do ([NAME] Don't Like It)
D:\temp\music\11 - go freaky (H-Blockx).mp3 | H-Blockx | Time to Move | Go Freaky
D:\temp\music\13 - time to fight (H-Blockx).mp3 | H-Blockx | Time to Move
Spreadsheet: 007f2a0e-aa7e-4866-bb41-0716eebaf0dd
Sheet: Sheet1

Table 1--U.S. rice supply and use  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14
 |  |  |  |  |  |  | 2/
TOTAL RICE |  |  |  | Million acres
Area:
Planted | 2.761 | 2.995 | 3.135 | 3.636 | 2.689 | 2.699 | 2.485
Harvested | 2.748 | 2.976 | 3.103 | 3.615 | 2.617 | 2.678 | 2.464
 |  |  |  | Pounds per harvested acre
Yield | 7219 | 6846 | 7085 | 6725 | 7067 | 7449 | 7511
 |  |  |  | Million cwt
Beginning stocks | 39.315 | 29.492 | 30.419 | 36.499 | 48.467 | 41.07900000000004 | 36.42300000000006
Production | 198.388 | 203.733 | 219.85 | 243.104 | 184.941 | 199.479 | 185.077
Imports | 23.9 | 19.218 | 19.023 | 18.338 | 19.359 | 21.062 | 22.5
Total supply | 261.603 | 252.443 | 269.292 | 297.941 | 252.767 | 261.6200000000001 | 244.0000000000001
Food, industrial,
& residual 3/ | 123.152 | 123.77 | 119.947 | 133.603 | 107.505 | 115.038
Seed | 3.697 | 3.87 | 4.488 | 3.324 | 3.332 | 3.067
Total domestic use | 126.849 | 127.64 | 124.435 | 136.927 | 110.837 | 118.105 | 116
Exports | 105.262 | 94.384 | 108.358 | 112.547 | 100.851 | 107.092 | 98
Rough | 37.663 | 31.633 | 40.351 | 34.595 | 32.94 | 34.165 | 35
Milled 4/ | 67.599 | 62.751 | 68.007 | 77.952 | 67.911 | 72.927 | 63
Total use | 232.111 | 222.024 | 232.793 | 249.474 | 211.688 | 225.197 | 214
Ending stocks | 29.49200000000002 | 30.41899999999998 | 36.49900000000002 | 48.46700000000004 | 41.07900000000004 | 36.42300000000006 | 30.00000000000006
 |  |  |  | Percent
Stocks-to-use ratio | 12.70598980660116 | 13.70077108781032 | 15.6787360444687 | 19.42767582994622 | 19.40544575034959 | 16.17383890549166 | 14.01869158878507
 |  |  |  | $/cwt
Average farm |  |  |  |  |  |  | 14.70 to
price 5/ | 12.8 | 16.8 | 14.4 | 12.7 | 14.5 | 14.9 | 15.7
 |  |  |  | Percent
Average
milling rate | 69.88 | 70.83 | 71.53 | 68.86 | 69.93 | 70 | 70.25
N/A = not available.  1/ August-July market year; rough equivalent.  2/ Projected.  3/ Residual includes unreported
use, processing losses, and estimating errors.  4/  Rough-rice equivalent.  5/ Market-year weighted average.
Source: World Agricultural Supply and Demand Estimates, WAOB, USDA.
Updated September 12, 2013.
Spreadsheet: 722236d1615128678-modify-my-formula-to-to-check-the-values-and-enter-the-result-and-if-no-values-enter-a-m-missing-and-sum
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | M | 2024-04-04 00:00:00 |  |  |  |  |  | P | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | will always .45 points |  |  | M8
 |  |  |  |  |  |  |  |  |  |  |  | if no value in the box get "M"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | we allocate a point system in order todetermine the strength of the box
 |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | will always get .33 points
 |  |  |  |  |  |  |  |  |  |  | Date of Birth |  |  |  |  |  |  |  |  | box |  |  |  |  |  |  |  |  |  |  | each will get 1 point
 |  |  |  |  | 4 |  |  |  |  | 3 |  |  |  |  |  | P | L | K
 |  |  |  |  | 9 |  |  |  |  | M |  |  | if the cells in the box have no values, we say that the numbers are missin so reprsented by "M"
 |  |  |  |  | 2 |  |  |  |  | 1 |  | here I need a formula that allocated points to each cell like t8=.45 and all other cells u8:aa8 will have 1 point each and
 |  |  |  |  |  |  |  |  |  |  |  | ab8 =.33 | We therafter need to sum the total from T8:u8 but end results must not be greater than 3  and result entered into cell M14
 |  |  |  |  |  |  |  |  |  |  |  | as in the case of K12 the value is 3 because e8:k8 total 3.45 rounded to 3
 |  |  |  |  |  |  |  |  |  |  |  | and in the case of m13 because the value is zero, (M)issing  gets pasted into there
 |  |  |  |  |  |  |  |  |  |  |  | the orange shaded cells will contain the fomula that I need help with
 |  |  |  |  |  |  |  |  |  |  |  | e8 will  allocated .45 points
 |  |  |  |  |  |  |  |  |  |  |  | f8 will be allocated 1 point
 |  |  |  |  |  |  |  |  |  |  |  | g8 will be allocated 1 point |  |  |  |  |  | sum total must max 3 points if it’s a decimal must be rounded of greater.5 next number  max 3 points which be 100 % if its 2points 66% and 1 point 33%
 |  |  |  |  |  |  |  |  |  |  |  | h8 will gets no points blank
 |  |  |  |  |  |  |  |  |  |  |  | i8 gets 1 point
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] gets 1 point |  |  |  |  |  |  |  |  |  |  | M12 | will be *.45+1+1+0+1 |  |  |  |  | 3.45 | round 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  | k8 get .45 points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M14  will be *45+1 = 1.45 so will be 1 rounded and will get 33%
 |  |  |  |  |  |  |  |  |  |  |  | and if all the cells in the box are empty , it wiil get a "M" meaning that its missing points
 |  |  |  |  |  |  |  | I tried to use some identifiers that may help to make it a little clearer
Spreadsheet: 65889d1266517167-match-formula-excel-help-2-18-10
Sheet: Sheet2

I need a formula in the yellow below that looks at Sheet1 and returns the correct row number that the "AA" data or "BB" data or "CC" data is in for the corresponding person
[NAME]
AA
BB
CC
[NAME]
AA
BB
CC
[NAME]
AA
BB
CC
Tiffany
AA
BB
CC
Will
AA
BB
CC
[NAME]
AA
BB
CC
Spreadsheet: 165695d1341322379-sum-of-maxs-based-on-multiple-criteria-sampel-book
Sheet: Data

DateOfService | Day of the week | PrimaryP | SupervisingP | M/C | PrimSuper | Primary | Supervisory | Total Time
2012-05-01 00:00:00 | Tuesday | [NAME] |  | M |  |  |  | 0:41:00
2012-05-02 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 0:52:00
2012-05-02 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 8:10:00
2012-05-02 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 0:55:00
2012-05-03 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 3:40:00
2012-05-03 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 1:51:00
2012-05-03 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 4:25:00
2012-05-03 00:00:00 | Tuesday | [NAME] |  | M |  |  |  | 1:35:00
2012-05-03 00:00:00 | Tuesday | [NAME] | [NAME] | C |  |  |  | 1:10:00
Spreadsheet: 836043d1689066063-summary-across-multiple-sheets-and-reference-list-excel-linup-help-game-lineup-2023-07-07
Sheet: G4 - 3 - TBD

Date: |  | 2023-07-09 00:00:00 |  |  | Field: |  |  | Start Time: |  | 14:45:00
Home: |  | SYB 8U All Star Black |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | First Name | Last Name | Number
1 | 12 | Player | One | 1 | LCF | LCF | LCF | SS | SS | SS |  |  |  |  | Player | One | 1
2 | 11 | Player | Two | 2 | SS | SS | SS | LF | LF | LF |  |  |  |  | Player | Two | 2
3 | 1 | Player | Three | 3 | 1B | 1B | 1B | LCF | LCF | LCF |  |  |  |  | Player | Three | 3
4 | 2 | Player | Four | 4 | X | X | P | 1B | 1B | 1B |  |  |  |  | Player | Four | 4
5 | 4 | Player | Five | 5 | LF | LF | LF | 2B | 2B | 2B |  |  |  |  | Player | Five | 5
6 | 5 | Player | Six | 6 | 2B | 2B | 2B | RCF | RCF | RCF |  |  |  |  | Player | Six | 6
7 | 10 | Player | Seven | 7 | 3B | 3B | 3B | RF | RF | RF |  |  |  |  | Player | Seven | 7
8 | 9 | Player | Eight | 8 | RF | RF | RF | P | C | C |  |  |  |  | Player | Eight | 8
9 | 6 | Player | Nine | 9 | RCF | RCF | RCF | 3B | 3B | 3B |  |  |  |  | Player | Nine | 9
10 | 7 | Player | Ten | 10 | C | C | X | X | P | P |  |  |  |  | Player | Ten | 10
11 | 8 | Player | Eleven | 11 | P | P | C | C | X | X |  |  |  |  | Player | Eleven | 11
Out
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
Spreadsheet: 815247d1674832812-take-the-qty-out-of-stock-vehicle-parts-pricing
Sheet: Prices

 | Stock Codes
Date Purchased | Part # | Description | UOM | Purchase Price | Quantity in Stock | Vehicle and year | Price | Column1 | Column2 | Column3 | Average Cost |  | Part | Price |  | Sheets
2022-07-07 00:00:00 | 14C24 | [NAME] | ea. | 1.92 | 10 | 2005-2022 Frontier driver's side |  |  |  |  |  |  | 14C24 |  |  | #35
2022-07-07 00:00:00 | 14C18 | [NAME] | ea. | 1.92 | 10 | 2005-2022 Frontier passenger's side |  |  |  |  |  |  | 14C18 |  |  | #21
2022-07-07 00:00:00 | 5486WS | Air Filter | ea. | 3.72 | 10 | 2005-2021 Engine Air Filter |  |  |  |  |  |  | 5486WS |  |  | #23
2022-07-07 00:00:00 | F4683 | Cabin Air Filter | ea. | 4.25 | 10 | 2005-2020 Cabin Air Filter |  |  |  |  |  |  | F4683 |  |  | #25
2022-07-07 00:00:00 | Shipping |  |  | 15.4 | 2 | Shipping Cost |  |  |  |  |  |  |  |  |  | #30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #97
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #61
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #26
Spreadsheet: 684427d1593359353-indirect-function-looking-for-worksheet-named-after-current-year-sample
Sheet: Summary

 |  |  |  |  |  |  | Trying to eliminate sheet1 by referencing the worksheet with the matching year. For this formula, I'm wanting to reference the current year.
 | [NAME] |  | column2 | column3 |  |  | [NAME] in column 2 references sheet1 currently
 | sheet2 |  |  | 2020-07-01 00:00:00 |  |  | cell [NAME])
 |  |  |  |  |  |  | I want it to dynamically reference the table on the worksheet that = the current year, using the INDIRECT function
 |  |  |  |  |  |  | Note: the table location is different than it was on sheet1. it is now [NAME]:AD18
 |  |  |  | Working samples of my indirect usage are in cells B14 and I14:[NAME]
 |  | <---SUM(INDIRECT(YEAR(TODAY())&"!text")) |  |  |  |  | 2019 |  | <----INDIRECT("'"&H14&"'!Total")
 |  |  |  |  |  |  |  |  | <----INDIRECT("'"&H15&"'!Total")
Spreadsheet: 11ae4340-1dbe-4806-98d1-a1e3e94d379b
Sheet: Sheet1

North American Association of Central Cancer Registries | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2011 ANNUAL CONFERENCE
NCRA Event Number  2011-068
It is your responsibility to document the session that you attended.
Please keep this form for your credential submission.
Name: |  |  | Total Hours:
 | TOPIC | SPEAKER | CE HOURS APPROVED | HOURS ATTENDED
2011-06-21 00:00:00 | Conference Day 1, Tuesday
08:30:00 | Cancer Surveillance & Health Care Reform in the US | [NAME], MD, MPH | 0.5
09:00:00 | The Impact of Cancer Survival Studies on Health Policy | [NAME], BA. BM, [NAME], [NAME], FFPH | 0.5
09:30:00 | Using Cancer Surveillance Data in Health Policy Development: Addressing Sustainability While Maximizing Outcomes | [NAME], BSN, MS | 0.5
10:00:00 | Discussion |  | 0.25
10:45:00 | Using Cancer Surveillance Data to Understand Genetic Differences in Colon Cancer Risk | [NAME], MD, PhD, MPH | 0.5
11:15:00 | The HER2neu Story and Its Impact on Cancer Surveillance | [NAME], MD | 0.5
11:45:00 | Discussion |  | 0.25
13:30:00 | Concurrent Session 1 |  | 1.5
15:30:00 | Concurrent Session 2 |  | 1.5
2011-06-22 00:00:00 | Conference Day 2, Wednesday
07:00:00 | Birds Of A Feather: Electronic Health Record - Where is it? What Does it Mean to You? | [NAME]; [NAME] | 1
08:00:00 | Concurrent Session 3 |  | 1.5
10:00:00 | Electronic Cancer Data Sharing for Research: Opportunities and Challenges | [NAME], MD, PhD | 0.5
10:30:00 | Electronic Physician Reporting in the Emerging E-Health Environment | [NAME], MS | 0.5
11:00:00 | Discussion |  | 0.25
2011-06-23 00:00:00 | Conference Day 3, Thursday
08:30:00 | Concurrent Session 4 |  | 1.5
10:30:00 | Concurrent Session 5 |  | 1.5
14:00:00 | NAACCR Showcase | [NAME], PhD; Dennis Deapen, DrPH; J [NAME]; [NAME], MPH, CTR | 1
15:00:00 | The Finish Line | [NAME], PhD; [NAME], DMD, SM, ScD; [NAME], PhD, MPH, CTR | 1
Total Hours |  |  | 14.75
Spreadsheet: 841518d1693698908-update-the-values-in-a-column-based-on-matching-data-in-other-columns-intended-result
Sheet: Sheet1

TIME | DC
1030 | 9
1031 | 9
1032 | 9
1033 | 9
1034 | 9
1035 | 9
1036 | 9
1037 | 9
1038 | 9
1039 | 9
1040 | 9
Spreadsheet: 866048d1712984077-help-for-creating-major-league-table-24
Sheet: Initial Setup

Number of Clubs | 24 |  | No | Club Name
 |  |  | 1 | Memphis | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | Charleston | ç | Club Name entried here won't be processed
 |  |  |  | Colorado S. | ç | Club Name entried here won't be processed
 |  |  |  | Detroit City | ç | Club Name entried here won't be processed
 |  |  |  | El Paso | ç | Club Name entried here won't be processed
 |  |  |  | FC Tulsa | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | Indy Eleven | ç | Club Name entried here won't be processed
 |  |  |  | Las Vegas L. | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | Louisville City | ç | Club Name entried here won't be processed
 |  |  |  | Miami FC | ç | Club Name entried here won't be processed
 |  |  |  | [NAME] | ç | Club Name entried here won't be processed
 |  |  |  | New Mexico | ç | Club Name entried here won't be processed
 |  |  |  | Oakland Roots | ç | Club Name entried here won't be processed
 |  |  |  | Orange County | ç | Club Name entried here won't be processed
 |  |  |  | Phoenix Rising | ç | Club Name entried here won't be processed
 |  |  |  | Pittsburgh | ç | Club Name entried here won't be processed
 |  |  |  | Rio Grande | ç | Club Name entried here won't be processed
 |  |  |  | Sacramento R. | ç | Club Name entried here won't be processed
 |  |  |  | San Antonio | ç | Club Name entried here won't be processed
 |  |  |  | San Diego Loyal | ç | Club Name entried here won't be processed
 |  |  |  | Tampa Bay | ç | Club Name entried here won't be processed
Spreadsheet: 539027d1505927805-sort-by-month-into-two-separate-columns-sample-workbook-prc2
Sheet: Sheet1

Item No. | Item Code | PO Date | Unit Cost | Qty Received |  |  | Sum of Unit Cost |  | PO Date
1 | APT171750 | 2017-08-02 00:00:00 | 93.5 | 20 |  |  | Item Code | Item No. | Jul | Aug
2 | APT84 | 2017-08-10 00:00:00 | 100.03 | 2 |  |  | APT171750 | 1 |  | 93.5
3 | APT84BD | 2017-07-18 00:00:00 | 112.53 | 20 |  |  | APT84 | 2 |  | 100.03
4 | APT84BD | 2017-08-02 00:00:00 | 112.53 | 20 |  |  | APT84BD | 3 | 112.53
5 | APT84BD | 2017-08-23 00:00:00 | 112.53 | 10 |  |  |  | 4 |  | 112.53
6 | APT8626S | 2017-07-18 00:00:00 | 100.02 | 20 |  |  |  | 5 |  | 112.53
7 | APT8626S | 2017-08-02 00:00:00 | 100.02 | 20 |  |  | APT8626S | 6 | 100.02
8 | APT8626S | 2017-08-23 00:00:00 | 100.02 | 20 |  |  |  | 7 |  | 100.02
9 | APT88RENEW | 2017-08-23 00:00:00 | 126.19 | 10 |  |  |  | 8 |  | 100.02
10 | APTBIONOVUSE | 2017-07-13 00:00:00 | 85 | 48 |  |  | APT88RENEW | 9 |  | 126.19
11 | APTEZBIO14 | 2017-07-13 00:00:00 | 110 | 36 |  |  | APTBIONOVUSE | 10 | 85
12 | APTEZBIO14 | 2017-07-18 00:00:00 | 110 | 144 |  |  | APTEZBIO14 | 11 | 110
13 | APTEZBIO14 | 2017-08-09 00:00:00 | 110 | 72 |  |  |  | 12 | 110
14 | APTEZBIO14 | 2017-08-24 00:00:00 | 110 | 72 |  |  |  | 13 |  | 110
15 | APTFP17A | 2017-07-13 00:00:00 | 83 | 80 |  |  |  | 14 |  | 110
16 | APTFP17A | 2017-08-15 00:00:00 | 83 | 10 |  |  | APTFP17A | 15 | 83
17 | APTFP17A | 2017-08-15 00:00:00 | 83 | 80 |  |  |  | 16 |  | 83
18 | APTMPDCB | 2017-08-08 00:00:00 | 90 | 60 |  |  |  | 17 |  | 83
19 | APTMPDCB | 2017-08-15 00:00:00 | 90 | 10 |  |  | APTMPDCB | 18 |  | 90
20 | APTMPDCB | 2017-08-29 00:00:00 | 90 | 60 |  |  |  | 19 |  | 90
21 | B1150CT-A | 2017-07-14 00:00:00 | 38 | 50 |  |  |  | 20 |  | 90
22 | B1150CT-A | 2017-08-15 00:00:00 | 38 | 10 |  |  | B1150CT-A | 21 | 38
23 | BB12231 | 2017-07-24 00:00:00 | 34.45 | 4 |  |  |  | 22 |  | 38
24 | BB1517I | 2017-08-16 00:00:00 | 129 | 0 |  |  | BB12231 | 23 | 34.45
25 | BB1517I | 2017-08-16 00:00:00 | 129 | 1 |  |  | BB1517I | 24 |  | 129
26 | BB45 | 2017-08-02 00:00:00 | 32 | 1 |  |  |  | 25 |  | 129
28 | BB685I | 2017-07-05 00:00:00 | 18 | 50 |  |  | BB45 | 26 |  | 32
27 | BB685I | 2017-08-07 00:00:00 | 16.4 | 35 |  |  | BB685I | 27 |  | 16.4
29 | BB685I | 2017-08-16 00:00:00 | 18 | 16 |  |  |  | 28 | 18
30 | BB685I | 2017-08-16 00:00:00 | 18 | 34 |  |  |  | 29 |  | 18
31 | BB685I | 2017-08-29 00:00:00 | 18 | 60 |  |  |  | 30 |  | 18
32 | BB685P | 2017-07-19 00:00:00 | 39.1 | 10 |  |  |  | 31 |  | 18
33 | BB685P | 2017-08-23 00:00:00 | 41.054 | 20 |  |  | BB685P | 32 | 39.1
35 | BB912I | 2017-07-24 00:00:00 | 15 | 10 |  |  |  | 33 |  | 41.054
36 | BB912I | 2017-08-02 00:00:00 | 15 | 20 |  |  | BB912I | 34 |  | 13.9
34 | BB912I | 2017-08-07 00:00:00 | 13.9 | 100 |  |  |  | 35 | 15
37 | BB912I | 2017-08-11 00:00:00 | 15 | 20 |  |  |  | 36 |  | 15
38 | BB912I | 2017-08-16 00:00:00 | 15 | 30 |  |  |  | 37 |  | 15
39 | BB912I | 2017-08-29 00:00:00 | 14.55 | 10 |  |  |  | 38 |  | 15
 |  |  |  |  |  |  |  | 39 |  | 14.55
 |  |  |  |  |  |  | Grand Total |  | 745.1 | 1913.724
Spreadsheet: 832631d1686498096-help-showing-biggest-and-smallest-values-from-a-range-as-a-name-test-book
Sheet: Sheet1

 | Days Of The Week | Times Played | Wins | Losses | Profit and Loss
 | Monday | 7 | 22 | 4 | 34.44 |  |  |  |  | Most Played Day Of The Week
 | Tuesday | 4 | 15 | 2 | 77.32
 | Wednesday | 9 | 28 | 1 | 12.54
 | Thursday | 12 | 7 | 6 | 10.55 |  |  |  |  | Day With Most Wins
 | Friday | 6 | 11 | 3 | 8.97
 |  |  |  |  |  |  |  |  |  | Day With Most Profit
 |  |  |  |  |  |  |  |  |  | Day With Least Profit
Spreadsheet: 824768d1680809849-sumifs-based-on-4-criteria-and-grouped-by-date-sumifs-4-criteria-grouped-by-date-3-forum
Sheet: data

Product Number | Serial Number | Region Number | Date | Customer | Sales
89 | 70 | 45 | 2022-11-12 00:00:00 | Customer1 | 200
25 | 23 | 26 | 2022-11-13 00:00:00 | Customer1 | 308
26 | 73 | 80 | 2022-11-14 00:00:00 | Customer2 | 392
78 | 71 | 97 | 2022-11-15 00:00:00 | Customer1 | 279
29 | 40 | 46 | 2022-11-16 00:00:00 | Customer2 | 432
25 | 23 | 26 | 2022-11-17 00:00:00 | Customer3 | 137
22 | 52 | 44 | 2022-11-18 00:00:00 | Customer1 | 521
68 | 45 | 61 | 2022-11-19 00:00:00 | Customer1 | 526
71 | 51 | 57 | 2022-11-20 00:00:00 | Customer2 | 491
25 | 23 | 26 | 2022-11-21 00:00:00 | Customer3 | 636
50 | 75 | 25 | 2022-11-12 00:00:00 | Customer1 | 158
25 | 23 | 26 | 2022-11-13 00:00:00 | Customer1 | 618
25 | 23 | 26 | 2022-11-14 00:00:00 | Customer2 | 611
13 | 10 | 33 | 2022-11-16 00:00:00 | Customer2 | 584
77 | 43 | 24 | 2022-11-17 00:00:00 | Customer3 | 166
25 | 23 | 26 | 2022-11-18 00:00:00 | Customer1 | 315