tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1734cf15-d043-4aa2-be37-3233ccdad163
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MA24 | Test | MA24 | Microalbuminuria, 24 Hour, [NAME] | Microalbuminuria, 24 Hr, U | Immunoturbidity | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. Mix well before taking 5-mL aliquot. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Preferred Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	No Toluene	Yes 6N HNO3	No Boric Acid	Yes Thymol	Yes | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 24-Hour excretion: <30 mg/24 hours Excretion rate: <20 mcg/min | Monday through Sunday; Continuously | 1 day | Same day/1 day | 1 | 82043 |  |  |  |  | Rochester
MA24 | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
MA24 | Order Question | TM43 | Collection Duration |  | Plain Text
MA24 | Order Question | VL41 | [NAME] |  | Plain Text
MA24 | Result | MI24H | Microalbuminuria, 24 Hr, U | Microalbuminuria, 24 Hr, U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14956-7
MA24 | Result | 24HEX | 24 Hour Excretion | 24 Hour Excretion | Numeric |  |  |  |  | mg/24 h |  |  |  |  |  |  |  |  |  | 14956-7
MA24 | Result | VL41 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 19153-6
MA24 | Result | TM43 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
MA24 | Result | [NAME] | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/min |  |  |  |  |  |  |  |  |  | 14956-7
MA24 | Result | CONC3 | Concentration | Concentration | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 30003-8
Spreadsheet: 466931d1466515727-scatter-chart-needs-lines-to-connect-data-points-of-same-data-series-chart-help
Sheet: Current prices

 |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N
1GB | 1 |  |  |  |  |  | 14.85 |  |  | 31.45 | 34.99 |  | 36.96 |  | 19.99
1.5GB | 1.5 |  |  |  |  |  |  | 9.99 |  |  | 37.49 |  |  |  | 24.99
2GB | 2 | 7.99 | 7.99 | 20 |  | 17.99 | 17.85 |  |  |  |  |  |  | 34.99
3GB | 3 |  |  |  | 20 |  |  | 14.99 | 19.99 | 40.45 | 37.49 |  | 45.96
4GB | 4
5GB | 5 |  |  | 30 | 29.99 |  | 22.85 | 24.99
6GB | 6 |  |  |  |  |  |  |  |  | 49.46 | 45.45 |  | 54.96
 | 1 | 1.5 | 2 | 3 | 4 | 5 | 6
A |  |  | 7.99
B |  |  | 7.99
C |  |  | 20 |  |  | 30
D |  |  |  | 20 |  | 29.99
E |  |  | 17.99
F | 14.85 |  | 17.85 |  |  | 22.85
G |  | 9.99 |  | 14.99 |  | 24.99
H |  |  |  | 19.99
I | 34.99 | 37.49 |  | 37.49
J | 31.45 |  |  | 40.45 |  |  | 49.46
K
L | 36.96 |  |  | 45.96 |  |  | 54.96
M |  |  | 34.99
N | 19.99 | 24.99
Spreadsheet: 487319d1478019256-simple-nested-lookup-sampleworksheet_110116_122700
Sheet: After

Orchard | Apples | Pears | Berries
Spreadsheet: 25730d1217266257-problems-using-array-with-2007-book1
Sheet: Sheet2

 |  |  | Company | Sub-Company | Element | Breakdown | Result
 |  |  | A | 1 | A1 | AY
 |  |  | A | 2 | B1 | AX | False
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | False
 |  |  | B | 1 | B2 | AX | False
 |  |  | B | 2 | A1 | AY | False
Spreadsheet: 851406d1701648947-extract-multiple-dates-with-different-format-into-a-new-column-sample-date
Sheet: New 

CANCPenOrgDetails | Specimen_Collection_Date
pseudomonas aeruginosa           .05/27/2022 | 2022-05-27 00:00:00
CR-AB, 6/10/22 | 2022-06-10 00:00:00
CRE, CR-PA
MRSA           .11/25/2021 | 2021-11-25 00:00:00
CRE- SPUTUM           .11/26/2021 | 2021-11-26 00:00:00
CRP PSEUDOMONAS           .02/20/2021 | 2021-02-20 00:00:00
Psuedomonas           .02/25/2022 | 2022-02-25 00:00:00
Escherichia coli 10/9/2021 | 2021-10-09 00:00:00
05/10/2022 | 2022-05-10 00:00:00
pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00
KPC URINE 6/9/22 | 2022-06-09 00:00:00
pseudomonas aeruginosa           .06/14/2022 | 2022-06-14 00:00:00
[NAME] at Kindred BP
KLEBSIELL APNEUMONIAE           .01/19/2022 | 2022-01-19 00:00:00
CRE           ..
CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00
[NAME]           .06/15/2022 | 2022-06-15 00:00:00
CRAB           .05/10/2022 | 2022-05-10 00:00:00
CRAB and PSA CR           .05/04/2022 | 2022-05-04 00:00:00
CARBAPENEM RESISTANT PSEUDOMONAS AERUGINOSA           .07/26/2022 | 2022-07-26 00:00:00
CRE           .07/23/2022 | 2022-07-23 00:00:00
pseudomonas, 8/3/22 | 2022-08-03 00:00:00
Spreadsheet: 270264d1381425374-sumproduct-with-id-numbers-that-has-minus-signs-and-using-time-as-an-array-samplehelpv1
Sheet: DPS Hours

Actual ID | Start Time | End Time
13-01294-001 | 05:00:00 | 07:00:00
13-01294-002 | 12:00:00 | 01:00:00
13-01294-003 | 03:00:00 | 05:00:00
13-01294-004 | 21:30:00 | 23:30:00
13-01294-005 | 22:00:00 | 23:00:00
13-01294-006 | 19:00:00 | 20:00:00
13-01294-007 | 22:00:00 | 23:00:00
13-01294-008 | 12:01:00 | 02:01:00
13-01294-009 | 12:30:00 | 02:00:00
13-01294-010 | 04:00:00 | 04:30:00
13-01294-011 | 18:00:00 | 20:00:00
13-00842-012 | 20:00:00 | 22:00:00
13-00842-013 | 20:00:00 | 22:00:00
13-00842-014 | 20:00:00 | 22:00:00
13-00842-015 | 20:00:00 | 22:00:00
13-00842-085 | 20:00:00 | 23:59:00
13-00842-086 | 20:00:00 | 23:59:00
13-00842-016 | 20:00:00 | 22:00:00
13-00842-017 | 20:00:00 | 22:00:00
13-00842-018 | 20:00:00 | 23:00:00 |  |  | Sumproduct of 13-01294 | ???
13-00842-019 | 20:00:00 | 22:00:00 |  |  | Sumproduct of 13-00842 | ???
13-00842-020 | 20:00:00 | 22:00:00
13-00842-087 | 20:00:00 | 23:59:00
13-00842-088 | 20:00:00 | 23:59:00
13-00842-021 | 20:00:00 | 22:00:00
13-00842-022 | 20:00:00 | 22:00:00
13-00842-023 | 20:00:00 | 22:00:00
13-00842-024 | 20:00:00 | 22:00:00
13-00842-025 | 20:00:00 | 22:00:00
13-00842-089 | 20:00:00 | 23:59:00
13-00842-090 | 20:00:00 | 23:59:00
13-00842-026 | 20:00:00 | 22:00:00
13-00842-027 | 20:00:00 | 22:00:00
13-00842-028 | 20:00:00 | 22:00:00
13-00842-029 | 20:00:00 | 22:00:00
Spreadsheet: 648714d1573159690-how-many-unique-zipcodes-and-how-many-of-each-zipcode-xlf-count-unique-zip-codes
Sheet: Sheet1

Zip Code |  | Unique | Count
44060
44060
44060
44113
44113
44112
44112
Spreadsheet: be9599d0-16dc-4c86-b5c4-f4a700cbba91
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40186416 | 2014-02-22 22:20:58 | AXIS | 1 | 6 | 5 | 778487 | mudslapper | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
40186741 | 2014-02-22 22:39:46 | ALLIES | 1 | 6 | 2 | 778487 | mudslapper | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
40265103 | 2014-02-27 14:38:18 | AXIS | 0 | 2 | 6 | 1443685 | david.kahn | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
Spreadsheet: 53718d1253638351-create-a-questionnaire-in-excel-700449-create-a-questionnaire-in-excel
Sheet: Pipeline

Telesales
2009-09-22 00:00:00
[NAME]
Please select the following telesales channel 'types' used in the [NAME] channel.
New Account Sales |  | Cross Sell Activity |  | Lead Generation |  | Retention |  | Account Management
For each option selected, please indicate if inbound, outbound, or both methods are used.
New Account Sales | Inbound |  |  | Outbound
Cross Sell Activity | Inbound |  |  | Outbound
Lead Generation | Inbound |  |  | Outbound
Retention | Inbound |  |  | Outbound
Account Management | Inbound |  |  | Outbound
Spreadsheet: 79461d1279723622-conditional-partially-coping-of-rows-in-excel-something-like-this-maybe
Sheet: Database

[NAME] | Date | Country | Status | Closing Date | Reference | Status  Ins. | Germany | Poland | Romania
x | 2010-04-13 00:00:00 | Romania | PAO |  |  |  |  |  | 2
x | 2010-05-20 00:00:00 | Romania | CG
x | 2010-05-28 00:00:00 | Poland | PAO |  |  |  |  | 4
x | 2010-06-07 00:00:00 | Poland | CG
x | 2010-01-03 00:00:00 | Romania | PAO | Q2 2010 | x |  |  |  | 6
x | 2010-06-29 00:00:00 | Romania | PAO |  |  |  |  |  | 7
x | 2010-02-22 00:00:00 | Poland | CG
x | 2010-04-13 00:00:00 | Romania | CG
x | 2010-04-14 00:00:00 | Romania | CG
x | 2010-04-15 00:00:00 | Romania | CG
x | 2010-04-16 00:00:00 | Poland | CG
x | 2010-04-17 00:00:00 | Poland | CG
x | 2010-04-18 00:00:00 | Poland | CG
x | 2010-04-19 00:00:00 | Poland | PAO | Q3 2010 |  |  |  | 15
x | 2010-04-20 00:00:00 | Poland | CG
x | 2010-04-21 00:00:00 | Romania | CG
x | 2010-04-22 00:00:00 | Poland | PAO | Q3 2010 | x |  |  | 18
x | 2010-04-23 00:00:00 | Poland | CG
x | 2010-04-24 00:00:00 | Germany | CG
x | 2010-04-25 00:00:00 | Poland | CG
x | 2010-04-26 00:00:00 | Romania | CG
x | 2010-04-27 00:00:00 | Romania | PAO |  |  |  |  |  | 23
x | 2010-04-28 00:00:00 | Poland | CG
x | 2010-04-29 00:00:00 | Poland | PAO | Q4 2010 |  |  |  | 25
x | 2010-04-30 00:00:00 | Germany | CG
x | 2010-05-01 00:00:00 | Germany | PAO | Q3 2010 |  |  | 27
x | 2010-05-02 00:00:00 | Poland | PAO | Q3 2010 | x |  |  | 28
x | 2010-05-03 00:00:00 | Romania | CG
x | 2010-05-04 00:00:00 | Romania | CG
Spreadsheet: a5ec482d-9d5f-43c6-a626-7138bd139bd2
Sheet: BAAG

 |  | YOUR BENEFITS AT A GLANCE
 |  | Effective Date:
 |  | Office Visits
 |  | Primary
 |  | Specialist
 |  | Chiropractic
 |  | [NAME]
 |  | Blood/Lab Tests
 |  | Hospital - In & Out-Patient Services
 |  | Deductible per                                                        Calendar year
 |  | In Patient Services
 |  | Out Patient Services
 |  | MRI's/CT/PET Scans
 |  | Emergency Room
 |  | Urgent Care
 |  | Out of Pocket:
 |  | [NAME] are capped at two per family
 |  | Prescription Drugs |  | Covered - Tiered Copays | Covered - Tiered Copays | Covered - Tiered Copays | Covered - Tiered Copays | Covered - Tiered Copays
Spreadsheet: 130196d1322126055-countifs-with-a-unique-identier-countif_sheet
Sheet: Sheet1

ID | Text 1 | Text 2 | Text 3
1 | [NAME] | SomeText | 3C |  | MY COUNTIF |  |  | * If Text1 == [NAME], Text 2= SomeText , Text 3 == 2A
2 | [NAME] | SomeText | 3C |  | WHAT THE VALUE SHOULD BE |  |  | 2 | * If Text1 == [NAME], Text 2= SomeText , Text 3 == 2A, ID is Unique/Counted Once |  |  |  |  |  |  |  | : So need a third criterion that states that ID must be unique (as in only counted once per matching Id)
2 | [NAME] | SomeText | 2A
2 | [NAME] | SomeText | 3C
3 | [NAME] | SomeText | 2A
12 | [NAME] | SomeText | 3C
12 | [NAME] | SomeText | 2A
12 | [NAME] | SomeText | 2A
Spreadsheet: 739802d1625955899-xlookup-more-than-3-results-from-data-set-tracker-for-sharing-2
Sheet: Calendar

Month | July - P7 |  |  |  | August - P8 |  |  |  | September - P9 |  |  |  |  | October - P10 |  |  |  | November - P11 |  |  |  | December - P12
Week No | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 | 202127 | 202128 | 202129 | 202130 | 202131 | 202132 | 202133 | 202134 | 202135 | 202136 | 202137 | 202138 | 202139 | 202140 | 202141 | 202142 | 202143 | 202144 | 202145 | 202146 | 202147 | 202148 | 202149 | 202150 | 202151 | 202152
Trial
Rollout
Spreadsheet: 119135d1314214241-error-need-help-with-formula-opo-accounts
Sheet: AMERIPRIDE (O1200057)

OPEN PURCHASE ORDER TALLY SHEET
AMERIPRIDE |  |  |  | 101001-42110-5503-650000
VENDOR |  |  |  | BUDGET CATEGORY
DATE | INVOICE | P.O. # | EXPENDITURE | BALANCE | REMARKS
2010-07-01 00:00:00 |  | O1200057 |  | 18000
2011-07-21 00:00:00 | 1100558374 |  | 311.96
2011-07-21 00:00:00 | 1100562833 |  | 331.21
2011-07-21 00:00:00 | 1100567224 |  | 309.63
2011-08-08 00:00:00 | 1100576036 |  | 368.92
2011-08-08 00:00:00 | 1100571385 |  | 303.42
2011-08-08 00:00:00 | 1100580447 |  | 303.01
2011-08-17 00:00:00 | 1100584837 |  | 331.57
2011-08-22 00:00:00 | 1100589279 |  | 325.32
2011-08-22 00:00:00 | 1110028605 |  | -41.83
2011-08-22 00:00:00 | 1110028606 |  | -142.06
Spreadsheet: 46937d1245855357-summary-report-off-multiple-criteria-help
Sheet: Sheet1

 | Client 1 | Client 2 | Client 3 | Client 4 | Client 5 | Client 6 | Client 7 | Client 8 | Client 9 | Client 10 | Total
Issue 1 | 1 |  |  | 5 |  | 63 |  |  | 5 | 2 | 76
Issue 2 |  | 7 | 5 |  | 3 | 24 |  | 6 |  | 8 | 53
Issue 3 | 11 |  | 3 | 15 | 5 |  | 42 |  | 25 | 1 | 102
Issue 4 |  | 1 |  | 2 |  |  | 3 |  | 5 |  | 11
Issue 5 |  | 2 |  | 3 |  | 6 |  | 29 |  | 2 | 42
Issue 6 | 2 |  | 6 |  | 4 | 6 | 17 |  | 3 |  | 38
Issue 7 |  | 1 |  |  |  |  |  |  |  |  | 1
Issue 8 |  |  |  |  |  |  |  |  |  |  | 0
Issue 9 |  | 16 |  |  | 6 |  |  |  |  |  | 22
Issue 10 |  |  |  |  |  |  | 2 |  |  |  | 2
Issue 11 |  |  |  |  |  | 7 |  |  | 25 |  | 32
Issue 12 |  |  |  |  |  |  |  |  | 1 |  | 1
Issue 13 |  |  |  | 12 |  |  |  |  |  |  | 12
Issue 14 |  |  |  |  |  |  | 45 |  |  |  | 45
Issue 15 |  | 3 |  |  |  |  |  |  |  |  | 3
Issue 16 |  |  | 4 |  |  |  |  |  |  |  | 4
Issue 17 |  |  |  |  |  |  |  |  | 12 |  | 12
Issue 18 |  |  |  |  | 48 |  |  |  |  |  | 48
Issue 19 |  |  |  |  |  |  |  |  | 23 |  | 23
Issue 20 |  | 12 |  |  |  |  |  |  |  |  | 12
Total | 14 | 42 | 18 | 37 | 66 | 106 | 109 | 35 | 99 | 13 | 539
I need a summary something similar to this
 |  |  |  | Total Issues
 |  |  |  | 539
 |  | Client 6 |  |  |  | Client 7 |  | Out of the total issues I need to highlight the two biggest impacting Clients (total)
 |  | 103 |  |  |  | 109
 | Issue 1 |  | Issue 2 |  | Issue 14 |  | Issue 3 |  | Brake down client into top two issues
 | 63 |  | 24 |  | 45 |  | 42
P/N | QTY | P/N | QTY | P/N | QTY | P/N | QTY
12345 | 25 | 34567 | 11 | 56789 | 23 | 78901 | 32 |  | Generate a list of top affecting partnumbers by issue.
23456 | 19 | 45678 | 7 | 67890 | 17 | 89012 | 7 |  | all raaw data is all categorised based on issue
Thank you in advance for your help, have been stuck on how to automate this for a few days.
Spreadsheet: 783201d1654662569-heading-no-to-come-in-the-excel-formula-headingno-should-come-
Sheet: Sheet1

Question | 1 | 2 | 3 | 4 | Strongly Agree | Agree | Disagree | Neither Agree nor Disagree
1 | Strongly Agree | Agree | Neither Agree nor Disagree | Disagree | 1 | 2 | 4 | 3
2 | Agree | Disagree | Neither Agree nor Disagree | Strongly Agree | 4 | 1 | 2 | 3
3 | Neither Agree nor Disagree | Disagree | Agree | Strongly Agree | 4 | 3 | 2 | 1
4 | Neither Agree nor Disagree | Agree | Disagree | Strongly Agree | 4 | 2 | 3 | 1
Spreadsheet: f8119825-5870-4b0e-90d0-00ddf663a123
Sheet: Table 6.3

6.3 Terms of trade
Quarter | 2010-11 | 2011-12 | 2012-13 | 2013-14 | 2014-15
Implicit price deflator for exports of goods and services (a) (b) – index
September | 107.8 | 116.7 | 100.6 | 105 | 95.1
December | 105.3 | 113.3 | 99.1 | 105
March | 110.5 | 105.4 | 100 | 105.7
June | 114.9 | 107.7 | 100.4 | 99
Annual average | 109.7029702970297 | 111.1879338802429 | 100 | 103.506644497506
Implicit price deflator for imports of goods and services (a) (b) – index
September | 102.1 | 98.5 | 99.4 | 106.8 | 106.2
December | 98.2 | 101.2 | 100.4 | 106.8
March | 98.4 | 99 | 100.3 | 109.5
June | 98.3 | 101.6 | 100.4 | 106.7
Annual average | 99.15503897666997 | 100.0877985149508 | 100 | 103.506644497506
Terms of trade (a) (b) (c) – index
September | 105.5 | 118.5 | 101.2 | 98.3 | 89.5
December | 107.2 | 112 | 98.7 | 98.3
March | 112.3 | 106.4 | 99.7 | 96.4
June | 116.8 | 106 | 100 | 92.8
Annual average | 110.6378167254228 | 111.0903981604051 | 100 | 96.26560398668012
(a) Quarterly figures are seasonally adjusted.
(b) Base: 2012-13 = 100.0.
(c) Index of the ratio of the implicit price deflator for exports of goods and services
to the implicit price deflator for imports of goods and services
Sources: | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=&
ABS, Balance of payments and international investment position, Cat. no. 5302.0
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 3rd March 2015
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 1177962 | 399370 | 1577332
FRA | 871989 | 174318 | 1046307
OIS | 210740 | 321893 | 532633
OTHER* | 13462 | 702099 | 715561
TOTAL | 2274153 | 1597680 | 3871833
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: 125785d1319215584-excel-2007-summarize-data-from-multiple-worksheets-with-multiple-criteria-sample-workbook
Sheet: Summary

Company | M-1 | Amount
1000 | A | 50
2000 | B | 100
3000 | C | 300
1000 | B | 150
2000 | C | 2
2000 | A | 2
3000 | B | 500
Pulling from the same sheet - works fine
 |  | 1000 | 2000 | 3000
 | A | 50 | 2 | 0
 | B | 150 | 100 | 500
 | C | 0 | 2 | 300
Trying to pull from sheet 1000:3000
 |  | 1000 | 2000 | 3000 | …
 | A | 0 | 0 | 0
 | B | 0 | 0 | 0
 | C | 0 | 0 | 0
 | …
This summary sheet will have A-Z but each detail sheet may not have all of those letters. Rather than doing a sumif and linking directly to each detail sheet (over 200), I am hoping there is a formula that I could drag across in the summary sheet that will be able to match the company # and then match the corresponding letter and enter in the amt on the summary sheet. If the letter does not exist, I need to formula to show zero rather than #N/A so I can sum each company on the summary tab.
Spreadsheet: darron_c_giron__7905__LincolnLS
Sheet: 2001 (2)

 |  | Lincoln LS Sport
 |  | Invoice | MSRP |  | TMV
 | Base | 34978 | 37875
 | [NAME] | 874 | 1005
 | Destination | 610 | 610
 | Over Invoice | 500 |  |  | 0
 | Tax
 | Title | 100 |  |  | 100
 | License | 50 |  |  | 50
 | Ford Citibank | -417 |  |  | -1417
 | Driver Edge Citibank | -1118 |  |  | -1118
 | Down Payment | -2200 |  |  | -2200
 | Payment
 | Interest Rate | 0.08 |  |  | 0.08
 | Months | 60 |  |  | 60
Spreadsheet: 0430fb80-c103-4164-b0c3-d642d0366e51
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-26 09:27:29.670000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.906 | 101.781 | 101.656 | 101.281
3.75 | 101.692 | 101.567 | 101.442 | 101.067 |  | Note: | Refer To Price [NAME]
3.625 | 101.295 | 101.17 | 101.045 | 100.67 |  |  | For all Price Adjs
3.5 | 100.732 | 100.607 | 100.482 | 99.857
3.375 | 99.884 | 99.759 | 99.634 | 99.009
3.25 | 98.96 | 98.835 | 98.71 | 98.085
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 101.76 | 101.635 | 101.51 | 101.135
3.125 | 101.467 | 101.342 | 101.217 | 100.842
3 | 101.116 | 100.991 | 100.866 | 100.491
2.875 | 100.525 | 100.4 | 100.275 | 99.65
2.75 | 99.867 | 99.742 | 99.617 | 98.992
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-09 09:27:29.670000
30 DAY | 2012-08-24 09:27:29.670000
45 DAY | 2012-09-08 09:27:29.670000
60 DAY | 2012-09-23 09:27:29.670000
90 DAY | 2012-10-23 09:27:29.670000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 3677a9e6-b9da-4e48-b4b0-e6e2fdfa4ebb
Sheet: Sheet1

Trends in Beeld 2013 - [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Leerlinggewichten in het basisonderwijs
[NAME] het totale aantal leerlingen
 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006
0.25 | 0.1474229757634196 | 0.1369757103279428 | 0.1275085500419436 | 0.1184644218962063 | 0.1101711333548595 | 0.1025823111684958 | 0.07529867613819827
0.3 |  |  |  |  |  |  | 0.02357119793348402
0.9 | 0.1297659766966156 | 0.1303395399780942 | 0.1290572368845583 | 0.1262844955729335 | 0.1235389086212464 | 0.1206584893479664 | 0.08860187278010978
1.2 |  |  |  |  |  |  | 0.01407814013561511
 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
0.25 | 0.04804748491931082 | 0.02415511195418552
0.3 | 0.04251075673129405 | 0.05729450383311248 | 0.07572037731 | 0.07275331 | 0.06869739024649026 | 0.06472248630056507
0.9 | 0.05787530633405055 | 0.03046336038984036
1.2 | 0.02804901860332938 | 0.03966785272297151 | 0.05575655769 | 0.05520378 | 0.05426832201699855 | 0.05224478460108741
Bron: OCW, referentieraming 2013